Centos安装mysql的坑

cd /usr/local/src/

安装

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

yum -y install mysql-server

重启mysql

sudo service mysqld restart

获取随机的密码

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

登录数据库(第一次修改密码)

set global validate_password_policy=0;

set global validate_password_length=1;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'pwd';

完成！！！

设置远程连接

• use mysql;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pwd' WITH GRANT OPTION;

• flush privileges;

开启防火墙

• sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent
• sudo firewall-cmd --reload