centos安装mysql5.7

卸载残留

1. pkill -9 mysqld 停掉mysql进程
2. rpm -qa|grep -i mysql
3. yum -y remove **********

安装

1. wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
2. rpm -ivh mysql57-community-release-el7-8.noarch.rpm
3. yum -y install mysql-server

配置

1. vim /etc/my.cnf 修改端口号
2. service mysqld restart 重启服务
3. 重置密码
   • 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 该账号拥有分配权限）