centos 7.4安装mysql

1.下载安装包

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

2.运行安装包

yum -y install mysql57-community-release-el7-10.noarch.rpm

3.安装数据库,这步可能会花些时间，安装完成后就会覆盖掉之前的mariadb。

yum -y install mysql-community-server

4.启动服务

systemctl start mysqld.service

5.找密码

grep "password" /var/log/mysqld.log

    内容如下:

    2019-10-16T04:24:00.078079Z 1 [Note] A temporary password is generated for root@  

    ocalhost: oQ+-SPrhh4Bu

6.登录mysql并输入密码

mysql -uroot -p

7.修改密码

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

8.修改远程访问密码

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

flush privileges;