CentOS 安装MySQL

1、准备工作

• 查找出安装的mysql软件包和依赖包并卸载

  rpm -qa | grep mysql

• 查找出安装的mariadb数据库卸载mariadb

  rpm -qa | grep mariadb //查看mariadb rpm -e --nodeps mariadb-xxx //强制卸载mariadb

2、具体安装

1. 下载rpm安装包

   wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

2. 安装mysql源

   yum localinstall mysql57-community-release-el7-8.noarch.rpm

3. 检查mysql源是否安装成功

   yum repolist enabled | grep “mysql.-community.”

4. 开始安装mysql

   yum install mysql-community-server yum install mysql-community-devel

5. 启动mysql

   service mysqld start

6. 查看mysql启动状态

   service mysqld status

7. 设置开机启动

   systemctl enable mysqld systemctl daemon-reload

8. 获取mysql默认生成的密码

   grep ‘temporary password’ /var/log/mysqld.log

   注意：密码就是结尾冒号后面那一串 进入mysql命令行

   mysql -uroot -p Enter password:h8wobou+wpC

   如果成功进入mysql，linux前面的标识就会变成下面这种

   mysql>

9. 更换密码

   ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘123IsYourNewPassword!’;

   注意：这里的新密码必须包含数字、小写或大写字母、特殊字符串。这个密码的复杂程度，和validate_password_policy的值有关。 ​ 至此，mysql安装完成

3、置远程可以连接MySQL

​ 说明：

set global validate_password_policy=LOW; set global validate_password_length=4; GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION; FLUSH PRIVILEGES;