Differences

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

--- users_permissions [2015/04/02 21:57] – luke7858
+++ users_permissions [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 2: / Line 2: @@
 <sxh bash>
 SHOW GRANTS FOR 'user'@'x.x.x.x';
+</sxh>
+==== Database manipulation ====
+<sxh bash>
+SELECT........read only
+INSERT........insert rows/data
+UPDATE........change inserted rows/data
+DELETE........delete drop rows of data
+</sxh>
+=== Table Manipulation ===
+<sxh bash>
+Table manipulation:
+CREATE
+DROP
+ALTER
 </sxh>
 \\
@@ Line 15: / Line 35: @@
 <sxh bash>
 GRANT ALL PRIVILEGES ON *.* TO 'user'@'x.x.x.x';
+</sxh>
+\\
+====REMEMBER To Flush Privileges====
+<sxh bash>
+flush privileges;
 </sxh>
 \\