Centos安装mysql8

下载并安装mysql

1. wget -i -c https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

yum -y install mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql-community-server

在此会遇到的问题：

解决办法：执行命令 yum module disable mysql

然后重新执行：yum -y install mysql-community-server

遇到：Error: GPG check FAILED
yum install mysql-community-server --nogpgcheck

配置忽略大小写

因linux区分大小写，在这里需要设置一下

vim  /etc/my.cnf

在mysqld 下添加 lower_case_table_names=1

启动mysql，修改登录密码

1.查看原始密码：grep "password" /var/log/mysqld.log

2.登录mysql：mysql -uroot -p

alter user 'root'@'localhost' identified by 'password';

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

alter user 'root'@'%' identified with mysql_native_password by 'password';

修改完成后，赋权：`grant all privileges on *.* to 'root'@'%' ;
flush privileges;