下载
wget -i -c http://dev.mysql.com/get/mysql-community-common-5.7.33-1.el7.x86_64.rpm wget -i -c http://dev.mysql.com/get/mysql-community-libs-5.7.33-1.el7.x86_64.rpm wget -i -c http://dev.mysql.com/get/mysql-community-client-5.7.33-1.el7.x86_64.rpm wget -i -c http://dev.mysql.com/get/mysql-community-server-5.7.33-1.el7.x86_64.rpm
安装
yum -y install mysql-community-common-5.7.33-1.el7.x86_64.rpm yum -y install mysql-community-libs-5.7.33-1.el7.x86_64.rpm yum -y install mysql-community-client-5.7.33-1.el7.x86_64.rpm yum -y install mysql-community-server-5.7.33-1.el7.x86_64.rpm
启动服务
-- 启动服务 [root@localhost ~]# systemctl start mysqld.service -- 检查服务状态 [root@localhost ~]# systemctl status mysqld.service
服务配置
查看mysqld日志并用初始化密码登录——root@localhost:系统会自动默认匹配初始化密码
[root@localhost ~]# grep "password" /var/log/mysqld.log -- 输入查到的密码 [root@localhost ~]# mysql -u root -p -- 设置低密码等级 mysql-> set global validate_password_policy=LOW mysql-> set global validate_password_length=6; -- 修改密码 mysql-> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
设置远程登录
-- 1.切换mysql数据库 mysql> use mysql -- 2.执行查询,查看数据库当前有访问权限的信息 mysql> SELECT User, Host FROM user; -- 3.设置访问权限 mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; -- 4.刷新访问权限表(不要忘了) mysql> FLUSH PRIVILEGES;