1、在用户目录
cd ~
2、下载MySQL安装包
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
3、安装rpm包
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
4、修改MySQL的repo源,保证MySQL正常启用(最新版的不需要修改)
cd /etc/yum.repos.d/
vim mysql-community.repo
改成下图这样
5、安装MySQL server
yum -y install mysql-server
6、修改 MySQL 的访问权限
chown -R root:root /var/lib/mysql
7、启动MySQL
systemctl start mysqld
8、查看MySQL给的默认密码
cat /var/log/mysqld.log | grep password
9、登录进去修改密码
若想修改成简单的密码
执行:set global validate_password.policy=0;
执行:set global validate_password.length=1;
执行:ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
设置新密码及其加密规则:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
此时,密码设置完成,密码为123456
10、开启远程连接
执行:mysql -uroot –p123456进入MySQL
执行:show databases;
执行:use mysql;
执行:select Host,User from user \G;
执行:update user set Host = '%' where Host = 'localhost' and User = 'root';
执行:select Host,User from user \G; 查看是否更改
执行:flush privileges; 或者重启mysql服务器
此时,Navicat就可以远程访问数据库了