天天看點

centos7下mysql5.7的安裝.密碼修改.自啟動.配置遠端連接配接

1.安裝rpm源

rpm -Uvh

http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
centos7下mysql5.7的安裝.密碼修改.自啟動.配置遠端連接配接

2.安裝 MySQL

yum install -y mysql-community-server mysql-community-devel

centos7下mysql5.7的安裝.密碼修改.自啟動.配置遠端連接配接

3.MySQ和設定自啟動

systemctl start mysqld

systemctl enable mysqld

centos7下mysql5.7的安裝.密碼修改.自啟動.配置遠端連接配接

4.擷取mysql初始密碼:

grep 'temporary password' /var/log/mysqld.log

centos7下mysql5.7的安裝.密碼修改.自啟動.配置遠端連接配接

OmQAWGk0)q為mysql的root登入密碼

5.修改mysql的root密碼

mysql -uroot -p

centos7下mysql5.7的安裝.密碼修改.自啟動.配置遠端連接配接

ALTER USER 'root'@'localhost' IDENTIFIED BY 'P@ssw0rd';

centos7下mysql5.7的安裝.密碼修改.自啟動.配置遠端連接配接

FLUSH PRIVILEGES;

6.重新開機mysql

stystemctl restart mysqld

7.測試登入mysql

centos7下mysql5.7的安裝.密碼修改.自啟動.配置遠端連接配接

8.設定mysql允許任意ip遠端root登入到伺服器

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'P@ssw0rd' WITH GRANT OPTION;

centos7下mysql5.7的安裝.密碼修改.自啟動.配置遠端連接配接

9.Navicat測試遠端登入mysql伺服器

centos7下mysql5.7的安裝.密碼修改.自啟動.配置遠端連接配接

繼續閱讀