Differences

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

--- mysql_installation [2010/07/27 09:43] – created 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> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
-mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
+  mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' WITH GRANT OPTION;
-    ->     WITH GRANT OPTION;
-mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
+  mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
-mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
+  mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;
-    ->     WITH GRANT OPTION;
-mysql> CREATE USER 'admin'@'localhost';
+  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 'dummy'@'localhost';
+  mysql> CREATE USER 'admin'@'localhost';
+  mysql> GRANT RELOAD,PROCESS,CREATE,UPDATE ON database.table TO 'admin'@'localhost';
+  mysql> CREATE USER 'dummy'@'localhost';
 set rights
-FLUSH PRIVILEGES;
+  FLUSH PRIVILEGES;