linux下rpm安装mysql_linux 下rpm安装mysql 5.7

一、下载并安装MySQL官方的 Yum Repository

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

## 使用上面的命令就直接下载了安装用的Yum Repository，大概25KB的样子，然后就可以直接yum安装了。

yum -y install mysql57-community-release-el7-8.noarch.rpm

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

二、## 安装

yum install mysql-community-server

三、## 启动mysql

systemctl start mysqld

四、## 开机自启

systemctl enable mysqld

systemctl daemon-reload

## 因为安装了Yum Repository，以后每次yum操作都会自动更新，需要把这个卸载掉：

yum -y remove mysql57-community-release-el7-8.noarch

五、## 获取初始密码

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

##修改root密码

#密码强度设为最低等级0

#密码允许最小长度为1

set global validate_password_policy=0;

set global validate_password_length=1;

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

SHOW VARIABLES LIKE 'validate_password%';

六、## 授权root远程登录

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' ;

七、## 授权其他账号远程登录(同时也是创建一个账号)

CREATE USER 'admin'@'%' IDENTIFIED BY 'admin';

GRANT ALL ON *.* TO 'admin'@'%';

flush privileges ;

八、##新建数据库

CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARSET utf8 COLLATE utf8_unicode_ci;