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 查看临时随机密码
- mysql_secure_installation 重设新密码
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 mysql_native_password BY '123456';
- FLUSH PRIVILEGES;
