mysql5.7 安装 centos7下

wget安装 yum -y install wget

 

yum list installed | grep mariadb yum -y remove mariadb*

 

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

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

yum install mysql-server

 

启动mysql

service mysqld start

 

mysql5.7有默认密码 查看默认密码

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

 

mysql5.7设置简单密码

set global validate_password_policy=0; set global validate_password_mixed_case_count=0; set global validate_password_number_count=3; set global validate_password_special_char_count=0; set global validate_password_length=3;

 

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; (如果要限定某一个ip只要把%改为ip地址就可以了)

 

关闭防火墙 systemctl stop firewalld.service

或只开启端口

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