Create User : User Create « User Permission « SQL / MySQL

1. SQL / MySQL
2. User Permission
3. User Create

Create User

/*
mysql> /*
mysql> Create a user named Joe with the password Joe552 and
mysql> grant all privileges when logging in from any host.
mysql> */
mysql> GRANT ALL ON *.* TO Joe@'%' IDENTIFIED BY "Joe552";
Query OK, 0 rows affected (0.00 sec)

mysql> /* Verify the grant. */
mysql> SHOW GRANTS FOR Joe@'%';
+------------------------------------------------------------+
| Grants for Joe@%
                              |
+------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'Joe'@'%' IDENTIFIED BY PASSWORD '*F321704F1412
6CFD84206702826EAF46D265E927' |
+------------------------------------------------------------+
1 row in set (0.00 sec)

*/
/*
Create a user named Joe with the password Joe552 and 
grant all privileges when logging in from any host.

*/
GRANT ALL ON *.* TO Joe@'%' IDENTIFIED BY "Joe552";

/* Verify the grant. */

SHOW GRANTS FOR Joe@'%';
           
       

Related examples in the same category