- Login:
1mysql -uroot -ptest1234; - Show password policy:
1show variables like 'validate_password%'; - Show all databases
1show databases; - Backup DB:
1mysqldump -u root -p linux > /home/beinan/linuxsir031130.sql - Import DB:
1mysql -u root -p linux < /home/beinan/linuxsir031130.sql - Create a new user:
12345CREATE USER 'user'@'localhost' IDENTIFIED BY 'yourpassword';GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost';FLUSH PRIVILEGES;
Note:- ‘user’@’localhost’ 後面的localhost是指可以存取DB的IP,不是DB server的IP
- yourpassword不需要填加密的,直接用明碼就可以了
- ‘10.0.1.%’ could be replaced with ‘localhost’
Password generator: https://www.browserling.com/tools/mysql-password
Creating an user with adminer:
- 如果要讓user透過adminer登入,目前測試server欄位是一定要填%
Referece: