MySql: CentOS下安装MySql

1. 下载yum MySql安装包

https://dev.mysql.com/downloads/repo/yum/

2. 将文件放到CentOS服务器上

yum localinstall mysql80-community-release-el7-3.noarch.rpm

3. 安装

yum install mysql-community-server
可全选择 y

4. 检查是否安装了MySql及启动

rpm -qa|grep mysql
service mysqld start

5. 查看密码及登录

grep temporary password /var/log/mysqld.log
mysql -uroot -p

6. 修改密码并刷新权限

alter user root @ localhost identified by ******** ;
flush privileges;

7. 开启远程访问并重启MySql

use mysql;
update user set host= % where user= root ;