Differences

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

--- users_permissions [2015/03/30 18:28] – luke7858
+++ users_permissions [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-=== Mysql User Creation ===
+===Showing GRANTS for a user===
+<sxh bash>
+SHOW GRANTS FOR 'user'@'x.x.x.x';
+</sxh>
-<sxh bash>CREATE USER 'luke'@'x.x.x.x' IDENTIFIED BY 'testpassword';</sxh>
-=== Setting user password ===
+==== Database manipulation ====
+<sxh bash>
+SELECT........read only
-<sxh bash>SET PASSWORD FOR 'root'@'localhost'</sxh>
+INSERT........insert rows/data
-=== Deleting a user ===
+UPDATE........change inserted rows/data
-<sxh bash>drop user 'luke'@'x.x.x.x';</sxh>
+DELETE........delete drop rows of data
+</sxh>
+=== Table Manipulation ===
+<sxh bash>
+Table manipulation:
+CREATE
+DROP
+ALTER
+</sxh>
+\\
+=== Granting ALL Privileges on a db ===
+<sxh bash>
+GRANT ALL PRIVILEGES ON databasename.* TO 'user'@'x.x.x.x';
+</sxh>
+\\
+===Granting ALL Privileges on ALL dbs ===
+<sxh bash>
+GRANT ALL PRIVILEGES ON *.* TO 'user'@'x.x.x.x';
+</sxh>
+\\
+====REMEMBER To Flush Privileges====
+<sxh bash>
+flush privileges;
+</sxh>
+\\