1 查看Linux發(fā)行版本
[root@typecodes ~]# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)
2 安裝MySQL的Yum Repository
文檔詳見 A Quick Guide to Using the MySQL Yum Repository
3 啟動數據庫
[root@typecodes ~]# systemctl start mysqld.service
4 獲取初始密碼
使用YUM安裝并啟動MySQL服務后惰帽,MySQL進程會自動在進程日志中打印root用戶的初始密碼:
grep "password" /var/log/mysqld.log
5 修改root用戶密碼
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
Tips:解決 MySQL 5.7 中 Your password does not satisfy the current policy requirements. 問題
6 創(chuàng)建用戶并為用戶設置權限
CREATE USER 'dev' @'%' INDENTIFIED BY 'password';
grant all *.* to 'dev'@'%' INDENTIFIED BY 'password';
FLUSH PRIVILEGES;