mysql的安装

1》下载并安装MySQL官方的 Yum Repository：rpm -ivh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

2》查看当前可用的Mysql安装源：yum repolist enabled | grep "mysql.*-community.*"

3》3安装MySQL数据库： yum -y install mysql-community-server

4》启动mysql服务并设置开机启动：

　　　　systemctl start mysqld.service

　　　　systemctl enable mysqld.service

5》登陆mysql，安装好后，会在my.cnf文件中自动生成一个密码

　　1.查看随机密码：cat /var/log/mysqld.log | grep password

6》修改密码要注意密码策略要求： alter user 'root'@'localhost' identified by '密码';


 

当外网连接mysql时候：

       use mysql;

       update user set host='%' where user='root';

 

 

 

https://www.cnblogs.com/xuekun/p/9994375.html