cenos7下安装mysql

下载wegt命令

yum -y install wget

下载mysql安装包

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

安装服务

rpm -ivh mysql57-community-release-el7-8.noarch.rpm
cd /etc/yum.repos.d/
yum -y install mysql-server

启动mysql服务

systemctl start mysqld

登录

获取root用户临时密码

grep 'temporary password' /var/log/mysqld.log
mysql -uroot -p查询到的临时密码

修改mysql密码

set global validate_password_policy=LOW;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxx'; 

关闭防火墙

sudo systemctl disable firewalld

为root用户设置远程登录权限

mysql -uroot -pxxxxxx
use mysql;
update user set Host='%' where User='root';