Differences

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

--- mysql_installation [2010/07/27 09:44] – michael
+++ mysql_installation [2021/04/24 07:40] (current) – external edit 127.0.0.1
@@ Line 17: / Line 17: @@
-register user
+register user examples
   mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
   mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' WITH GRANT OPTION;
   mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
   mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;
   mysql> CREATE USER 'admin'@'localhost';
-  mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
+  mysql> GRANT RELOAD,PROCESS,CREATE,UPDATE ON *.* TO 'admin'@'localhost';
+  mysql> CREATE USER 'admin'@'localhost';
+  mysql> GRANT RELOAD,PROCESS,CREATE,UPDATE ON database.table TO 'admin'@'localhost';
   mysql> CREATE USER 'dummy'@'localhost';