卸载残留
- pkill -9 mysqld 停掉mysql进程
- rpm -qa|grep -i mysql
- yum -y remove **********
安装
- wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
- rpm -ivh mysql57-community-release-el7-8.noarch.rpm
- yum -y install mysql-server
配置
- vim /etc/my.cnf 修改端口号
- service mysqld restart 重启服务
- 重置密码
- grep "password" /var/log/mysqld.log 查看随机密码
- mysql -u root -p 登录
- ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';重置随机密码
- flush privileges 刷新权限
- CREATE USER 'newuser'@'%' IDENTIFIED BY '您的密码'; 增加新用户
- grant all on . to 'newuser'@'%' identified by '您的密码' with grant option; 分配权限(with grant option 该账号拥有分配权限)