|
/*
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@'%';
|