差異處

這裏顯示兩個版本的差異處。

--- mysql [2016/08/17 13:19]
jz
+++ mysql [2019/02/19 02:06] (目前版本)
jz [Change credential]
@@ 行 1: / 行 1: @@
-===== Auto complete CLI =====
+===== Install mycli =====
+[[https://github.com/dbcli/mycli|mycli]]
-Install mycli
-[[https://github.com/dbcli/mycli|mycli]]
 <code bash>
 yaourt -S mycli
 </code>
-Login to mysql shell
+===== Login to mysql shell =====
 <code bash>
 mycli -u root -p
@@ 行 15: / 行 13: @@
 ===== Create database =====
 <code sql>
-CREATE DATABASE menagerie;
+CREATE DATABASE newdatabase;
-USE menagerie
+USE newdatabase
 </code>
+===== Create user and grant the database access =====
+<code sql>
+CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'newpassword';
+GRANT ALL PRIVILEGES ON newdatabase.* TO 'newuser'@'localhost';
+</code>
 ===== Change credential =====
@@ 行 26: / 行 29: @@
 </code>
+<code mysql>
+SET PASSWORD FOR 'user'@'localhost' = PASSWORD('password');
+-- or
+update mysql.user set password=PASSWORD(‘新password’) where User=’root’;
+-- and then
+flush privileges;
+</code>
+===== Show users =====
+<code sql>
+select * from mysql.user;
+</code>
 ===== Show grants =====
@@ 行 33: / 行 48: @@
 SHOW GRANTS FOR username@localhost;
 </code>
+===== Remote grants =====
+<code sql>
+revoke all privileges on newdatabase.* from 'newuser'@'localhost';
+flush privileges;
+</code>
+===== List databases =====
+<code sql>
+SHOW DATABASES
+</code>
+===== List tables =====
+<code sql>
+SHOW TABLES
+</code>