差異處
這裏顯示兩個版本的差異處。
| Both sides previous revision 前次修改 下次修改 | 前次修改 | ||
|
mysql [2016/08/17 13:18] jz |
mysql [2019/02/19 02:06] (目前版本) jz [Change credential] |
||
|---|---|---|---|
| 行 1: | 行 1: | ||
| - | ===== Auto complete CLI ===== | + | ===== Install mycli ===== |
| - | + | ||
| - | Install mycli | + | |
| [[https://github.com/dbcli/mycli|mycli]] | [[https://github.com/dbcli/mycli|mycli]] | ||
| + | |||
| <code bash> | <code bash> | ||
| yaourt -S mycli | yaourt -S mycli | ||
| </code> | </code> | ||
| - | Login to mysql shell | + | ===== Login to mysql shell ===== |
| <code bash> | <code bash> | ||
| mycli -u root -p | mycli -u root -p | ||
| 行 15: | 行 13: | ||
| ===== Create database ===== | ===== Create database ===== | ||
| <code sql> | <code sql> | ||
| - | CREATE DATABASE menagerie; | + | CREATE DATABASE newdatabase; |
| - | USE menagerie | + | USE newdatabase |
| </code> | </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 ===== | ===== Change credential ===== | ||
| 行 26: | 行 29: | ||
| </code> | </code> | ||
| - | mysql> SHOW DATABASES; | + | <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> | ||
| - | mysql> select host, user, password from mysql.user; | + | ===== Show users ===== |
| - | mysql> SHOW GRANTS FOR username@localhost; | + | <code sql> |
| + | select * from mysql.user; | ||
| + | </code> | ||
| + | |||
| + | ===== Show grants ===== | ||
| + | <code sql> | ||
| + | SHOW DATABASES; | ||
| + | SELECT host, user, password FROM mysql.user; | ||
| + | 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> | ||
