Create a user named joe on localhost with a password of joe33 : User Create « User Permission « SQL / MySQL






  1. SQL / MySQL
  2. User Permission
  3. 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;








Related examples in the same category

1.Create User