centos安装mysql8

1. 卸载已有mysql

• rpm -qa | grep -i mysql
• yum -y remove ******** 卸载上面查出的
• find / -name mysql 删除分散mysql文件
• rm -rf /etc/my.cnf 删除配置文件
• rpm -qa|grep -i mysql 再次确认是否有残留

2. 下载安装rpm

• wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
• rpm -ivh mysql80-community-release-el7-1.noarch.rpm
• yum -y install mysql-server
• yum -y install mysql-server（如无启动可重启）

3. 重设密码

• grep 'password' /var/log/mysqld.log |head -n 1 查看临时随机密码
• mysqlsecureinstallation 重设新密码

4. 创建新账号并赋予全部权限

• use mysql;
• CREATE USER 'user1'@'%' IDENTIFIED BY '123456';
• grant all on . to 'user1'@'%'；
• ALTER USER 'user1'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
• ALTER USER 'user1'@'%' IDENTIFIED WITH mysqlnativepassword BY '123456';
• FLUSH PRIVILEGES;