Differences

This shows you the differences between two versions of the page.

--- view_create_and_delete_mysql_users [2016/08/03 08:58] – walkeradmin
+++ view_create_and_delete_mysql_users [2016/08/27 19:39] – [To Create a New User with all Privileges and a Password] walkeradmin
@@ Line 13: / Line 13: @@
 \\
 \\
-    To View Users
+==== To View Users ====
     SELECT user, host FROM mysql.user;
 \\
-    To Create a User
+==== To Create a User ====
     CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
@@ Line 29: / Line 29: @@
     GRANT ALL PRIVILEGES ON * . * TO 'admin'@'%';
 \\
-    To Delete a User
+==== To Create a New User with all Privileges and a Password ====
+    GRANT ALL PRIVILEGES ON mydb.* TO 'username'@'%' IDENTIFIED BY 'password';
+\\
+==== To Delete a User ====
     DROP USER 'jeffrey'@'localhost';