mysql在centos安装

1、下载yum源配置文件

下载地址为：http://dev.mysql.com/downloads/repo/yum/ 

 

2、安装yum源

rpm -Uvh mysql57-community-release-el6-n.noarch.rpm

查看yum源是否生效

yum repolist enabled | grep mysql

默认最新版生效，如果想用其他版本，参考官网指南

 

yum install yum-utils

yum-config-manager --disable mysql80-community

yum-config-manager --enable mysql57-community

3、安装mysql

yum install mysql-community-server

4、设置与启动mysql

vim /etc/my.cnf

启动mysql：systemctl start mysqld

5、修改初始密码

'root'@'localhost'用户的初始密码已经创建，如下查看

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

登录msql

mysql -uroot -p

修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

 

安装mysql遇到的问题

问题：Host 'xxx' is not allowed to connect to this MySQL server。

解决：

show databases; 查看所有数据库。

Use mysql; 选择mysql数据库

update user set host = '%' where user = 'root'; 将当前限制登录ip放开为所有

 

问题：Client does not support authentication protocol requested by server

解决：

网上查询解决方案为执行： ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘831015’;

结果报错ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'

经检查为mysql8.0的问题，进行了语法更改

执行：ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY'MySql2019!';

flush privileges;

然后连接正常。