Centos7 Mysql 5.7 安装配置

下载安装包

rpm -Uvh https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm

查看版本列表

yum repolist enabled | grep "mysql.*-community.*"

安装

yum install mysql-community-server -y

管理

systemctl start|stop|restart mysqld

配置

配置查看默认密码:   grep "temporary password" /var/log/mysqld.log
安全设置:   mysql_secure_installation
设置新密码：   set PASSWORD = PASSWORD('123456');
设置命令:   mysql_secure_installation
设置密码安全级别:   set global validate_password_policy=0;
设置密码长度:   set global validate_password_length=4;
应用管理开放远程连接：update user set host='%' where user='root' and host='localhost';
刷新权限：flush privileges;
创建一个远程访问的用户：grant all on *.* to 'remoteuser'@'%' identified by '123456';

Centos7 Mysql 5.7 安装配置

原文：https://www.cnblogs.com/AngryPigs/p/12219392.html