centos7最简单命令安装 mysql

下载

wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'

安装yum源文件

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

安装mysql

yum -y install mysql-community-server --nogpgcheck

启动

systemctl start mysqld

开机启动

systemctl enable mysqld

查看临时密码

grep 'temporary password' /var/log/mysqld.log

登录

mysql -uroot -pxxxxx

密码策略

set global validate_password_policy=0;
set global validate_password_length=1;

修改mysql密码

set password for root@localhost = password('123456')

修改mysql远程连接权限

use mysql;
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;