卸载MySQL

  1. # 查询已安装的列表
  2. rpm -qa|grep -i mariadb
  3. rpm -qa|grep -i mysql
  4. # 卸载查询到的MySQL
  5. rpm -ev --nodeps mysql-community-libs-xxx
  6. rpm -ev --nodeps mariadb-xxx
  7. # 查询残余文件夹
  8. find / -name mysql
  9. # 删除
  10. rm -rf  xxx/mysql
  11. # 删除/etc/my.cnf文件
  12. rm -rf /etc/my.cnf

安装MySQL

  1. # 安装基础组件
  2. yum install libaio perl net-tools
  4. # 依次执行以下命令安装
  5. rpm -ivh mysql-community-common-5.7.xxx
  6. rpm -ivh mysql-community-libs-5.7.xxx
  7. rpm -ivh mysql-community-client-5.7.xxx
  8. rpm -ivh mysql-community-server-5.7.xxx
  10. # 查询是否安装成功
  11. rpm -qa | grep mysql
  13. # 启动Mysql，并加入开机自启
  14. systemctl start mysqld
  15. systemctl stop mysqld
  16. systemctl enable mysqld
  18. # 使用Mysq初始密码登录数据库
  19. grep "password" /var/log/mysqld.log
  20. mysql -uroot -p
  21. # 输入刚刚查询到的密码
  23. # 修改密码
  24. set password for root@localhost = password('xxx');
  26. # 授权外网访问
  27. grant all on *.* to root@'%' identified by '数据库密码';
  28. flush privileges;
  30. # 开发防火墙端口号
  31. firewall-cmd --add-port=3306/tcp --permanent
  32. firewall-cmd --add-port=6379/tcp --permanent
  33. firewall-cmd --reload