Differences

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

--- view_create_and_delete_mysql_users [2016/08/03 08:48] – 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 9: / Line 9: @@
     mysql -u root -pPassword (no space between -p and your password)
+\\
+Once logged in you can do the following:
+\\
+\\
+==== To View Users ====
+    SELECT user, host FROM mysql.user;
+\\
+==== To Create a User ====
+    CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
+    Once created, the user requires permissions
+    GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
+    If you want to be able to access the server from anywhere, replace localhost with %
+    GRANT ALL PRIVILEGES ON * . * TO 'admin'@'%';
+\\
+==== 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';
+\\
 \\