卸载mariadb数据库
yum remove mariadb-libs.x86_64
下载Mysql源
https://dev.mysql.com/downloads/repo/yum/
安装mysql
yum localinstall mysql57-community-release-el7-8.noarch.rpm
安装mysql服务
yum install mysql-community-server
默认密码
cat /var/log/mysqld.log|grep "password"
连接mysql数据库:
mysql -h127.0.0.1 -uroot -p
设置密码复杂度
set global validate_password_policy=0;安全等级 判断密码的标准就基于密码的长度了
set global validate_password_length=1; 设置密码长度最短为1
远程连接:
show databases;
显示表
show tables;
选择user表
select * from user /G; /G格式化输出
选择user Host
select user,Host from user \G;
将user为root的Host改为% 即让所有用户进入
update user set Host = "%" where Host = "localhost" and User = "root"
刷新权限
flush privileges; 或者重启mysql连接
最后检查防火墙是否开启
ps -ef |grep firewalld
如果开启了,就把它关闭
sudo service firewalld stop