MySQL ​

安装教程 ​

系统：CentOS8 ​

1. 卸载原来的MySQL：rpm -qa |grep mysql --> rpm -e mysql-community-server-5.7.30-1.el7.x86_64

   mysql-community-server-5.7.30-1.el7.x86_64 为第一步查询出来安装的MySQL

2. 安装wget：yum install wget

3. 下载：wget http://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

4. 安装及配置：rpm -ivh mysql80-community-release-el7-3.noarch.rpm

   1. cd /etc/yum.repos.d/

   2. vim mysql-community.repo

      1、将 [mysql57-community] 下的 enabled 设置为1，表示打开5.7

      2、将 [mysql80-community] 下的 enabled 设置为0，表示关闭8.0

   3. yum module disable mysql

   4. yum -y install mysql-community-server

      错误：Error: GPG check FAILED 执行： yum install mysql-community-server --nogpgcheck

5. mysql --version

6. 启动mysql：systemctl start mysqld.service

7. 查看启动状态：systemctl status mysqld.service

8. 查看初始密码：grep "password" /var/log/mysqld.log

9. 登录：mysql -uroot -p

10. 修改密码：ALTER USER USER() IDENTIFIED BY '11!';

11. 修改远程可连接：

    1. use mysql;
    2. select user, host from user;
    3. update user set host = '%' where user = 'root';
    4. flush privileges;