第一步:在线下载MySQL Yum仓库:
Linux8:
wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm
Linux7:
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
第二步:安装MySQL Yum仓库:
Linux8:
rpm -ivh mysql80-community-release-el8-1.noarch.rpm
Linux7:
rpm -ivh mysql80-community-release-el7-3.noarch.rpm
更新仓库:
yum makecache
查看仓库:
yum repolist
可以看到MySQL的仓库安装成功
第三步:下载安装MySQL
yum -y install mysql-community-server.x86_64
安装路径为 /var/lib/mysql
第四步:启动配置MySQL:
启动MySQL:
systemctl start mysqld
设置MySQL开机自启动
systemctl enable mysqld
关闭防火墙:
systemctl stop firewalld
systemctl disable firewalld
第五步:测试MySQL
查看密码:
grep 'password' /var/log/mysqld.log
连接MySQL:
mysql -u root -p
输入密码(输入密码时,密码是不可见的),即可成功连接数据库
第六步:修改root密码:
修改密码强度验证设置:
--设置复杂程度
set global validate_password.policy=0;
--设置密码长度
set global validate_password.length=4;
修改密码(新密码不可为root):
ALTER user 'root'@'localhost' IDENTIFIED BY '新密码';
第七步:允许远程连接MySQL
修改mysql权限表
use mysql;
update user set host='%' where user='root';
flush privileges;
第八步:退出MySQL
exit