開發與維運

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

1.安裝rpm源
rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm

image.png
2.安裝 MySQL
yum install -y mysql-community-server mysql-community-devel
image.png
3.MySQ和設置自啟動
systemctl start mysqld
systemctl enable mysqld
image.png
4.獲取mysql初始密碼:
grep 'temporary password' /var/log/mysqld.log
image.png
OmQAWGk0)q為mysql的root登錄密碼
5.修改mysql的root密碼
mysql -uroot -p
image.png

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

image.png
FLUSH PRIVILEGES;

6.重啟mysql
stystemctl restart mysqld
7.測試登錄mysql
image.png
8.設置mysql允許任意ip遠程root登錄到服務器
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'P@ssw0rd' WITH GRANT OPTION;
FLUSH PRIVILEGES;
image.png
9.Navicat測試遠程登錄mysql服務器
image.png

Leave a Reply

Your email address will not be published. Required fields are marked *