Centos7默认安装了mariadb数据库
sudo yum remove mariadb-libs.x86_64 #移除mariadb
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm #进入tmp目录下载mysql的yum源
sudo yum localinstall mysql57-community-release-el7-8.noarch.rpm #安装mysql5.7的yum源
sudo yum search mysql #可以查看mysql的源最后一行就有了
sudo yum install mysql-community-server #下载安装mysql
sudo service mysqld start / restart #启动mysql服务
ps -ef | grep mysql #查看mysql的进程
sudo service mysql stop #停止mysql的服务
cat /var/log/mysqld.log | grep password #查看mysql自动生成的密码
mysql -uroot -pg*54t3zDy4Y? #进入数据库
提示必须重置密码
注意:如果只想设置简单密码需要修改两个全局参数:
set global validate_password_policy=0;
set global validate_password_length=1;
set PASSWORD = PASSWORD('123456'); #设置密码 后exit退出重新登陆
### mysql里面的语句(可以外部使用可视化工具链接)
use mysql;
show tables;
select Host,User from user \G
update user set host = '%' where Host = "localhost" and user = "root";
exit
###退出mysql 重启MySQL服务(前提也得关闭防火墙)
sudo service mysqld restart
成功链接