Linux 安装MySQL

1、准备工作
查找出安装的mysql软件包和依赖包并卸载

rpm -qa | grep mysql

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

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

2、具体安装
下载rpm安装包

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

安装mysql源

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

检查mysql源是否安装成功

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

开始安装mysql

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

启动mysql

service mysqld start

查看mysql启动状态

service mysqld status

设置开机启动

systemctl enable mysqld
systemctl daemon-reload

获取mysql默认生成的密码

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

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

mysql -uroot -p
Enter password:h8wobou+wpC

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

mysql>

更换密码

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;