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;
然后连接正常。