1.安裝rpm源
rpm -Uvh
http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5SZ1EmMkdTMxUDM0AzMxgTY1UzN0kTZzkzMhZWYwkDO58CX5d2bs92Yl1iclB3bsVmdlR2LcNWaw9CXt92Yu4GZjlGbh5yYjV3Lc9CX6MHc0RHaiojIsJye.png)
2.安裝 MySQL
yum install -y mysql-community-server mysql-community-devel
3.MySQ和設定自啟動
systemctl start mysqld
systemctl enable mysqld
4.擷取mysql初始密碼:
grep 'temporary password' /var/log/mysqld.log
OmQAWGk0)q為mysql的root登入密碼
5.修改mysql的root密碼
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'P@ssw0rd';
FLUSH PRIVILEGES;
6.重新開機mysql
stystemctl restart mysqld
7.測試登入mysql
8.設定mysql允許任意ip遠端root登入到伺服器
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'P@ssw0rd' WITH GRANT OPTION;
9.Navicat測試遠端登入mysql伺服器