Differences

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

--- mysql_installation [2010/07/27 10:31] – michael
+++ mysql_installation [2021/04/24 07:40] (current) – external edit 127.0.0.1
@@ Line 25: / Line 25: @@
   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';