Centos7 yum源安装MySQL5.7

使用wget下载官方yum源的rpm包

wgethttps://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

安装rpm包

rpm -ivh mysql57-community-release-el7-11.noarch.rpm

yum clean all

yum makecache

yum直接安装

yum install -y mysql-community-server

systectl start mysqld 启动

systemctl enable mysqld 设置为开机自启

登录，查看随机密码

cat /var/log/mysqld.log|grep ‘A temporary password’

永久修改密码长度和政策

vim /etc/my.cnf

[mysqld] 添加

validate_password_policy=0 密码政策

validate_password_length=0 密码长度

systemctl stop mysqld 关闭再启动

systemctl start mysqld

登录

mysql -u root -p 随机密码

use mysql

修改密码

设置root账号密码为root

alter user ‘root’@’localhost’ identified by ‘root’;

根据需求再增加远程登入权限

grant all privileges on.to root@’%’ identified by ‘root’;

flush privileges;

重启

systemctl restart mysqld

测试登入

mysql   -uroot -proot

可拿Robo 3T  等可视化工具来测试一下远程