Update README.md

Update 'README.md'
2024-03-04 15:30:21 +00:00 · 2024-03-04 15:29:59 +00:00 · 2023-05-13 17:48:57 +00:00
1 changed files with 21 additions and 0 deletions
--- a/README.md
+++ b/README.md
@@ -16,3 +16,24 @@ mysqldump -v -h $DB_HOST --user=$DB_USER -p"$DB_PASSWORD" $DB_NAME > $TARGET_FIL
 mysql -uroot -p database_name < file.sql
 ```

+## Misc
+```bash
+
+#list databases
+show databases;
+
+#use database;
+use <DATABASE NAME>;
+
+#list tables
+show tables;
+
+# list users
+SELECT user, host FROM mysql.user;
+
+# grant all permisions
+GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION;
+
+```
+
+
Author	SHA1	Message	Date
marcio.fernandes	49487a1239	Update README.md	2024-03-04 15:30:21 +00:00
marcio.fernandes	d9dec2358d	Update README.md	2024-03-04 15:29:59 +00:00
marcio.fernandes	1081f67f12	Update 'README.md'	2023-05-13 17:48:57 +00:00