SQL/MySQL/User Permission/User Create
Create a user named joe on localhost with a password of joe33
/*
mysql> GRANT ALL ON databaseName.sales TO joe@localhost IDENTIFIED BY "joe33";
Query OK, 0 rows affected (0.08 sec)
mysql> REVOKE DELETE, DROP, ALTER ON databaseName.sales FROM joe@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW GRANTS FOR joe@localhost;
+--------------------------------------+
| Grants for joe@localhost |
+--------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO "joe"@"localhost" IDENTIFIED BY PASSWORD "*97F8
429BFFF8381BDD2BBA8733F8AC7561051548" |
| GRANT SELECT ON `databasename`.* TO "joe"@"localhost" WITH GRANT OPTION
|
| GRANT SELECT, INSERT, UPDATE, CREATE, REFERENCES, INDEX ON `databasename`.`sal
es" TO "joe"@"localhost" |
+--------------------------------------+
3 rows in set (0.01 sec)
*/
/*
Create a user named joe on localhost with a password of joe33, who has
ALL privileges on the sales table, and then revoke the DELETE, DROP, and
ALTER privileges.
*/
GRANT ALL ON databaseName.sales TO joe@localhost IDENTIFIED BY "joe33";
REVOKE DELETE, DROP, ALTER ON databaseName.sales FROM joe@localhost;
SHOW GRANTS FOR joe@localhost;
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@"%";