linux通过rpm安装mysql,Linux下通过rpm安装MySQL

安装依赖包

$ yum install libaio

下载.rpm文件

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

安装rpm软件

$ yum install rpm

执行rpm文件

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

安装MySQL，Ubuntu下安装会出现错误，缺少依赖包

$ yum install mysql-community-server

缺少的依赖包：跳过依赖执行安装

$ yum install mysql-community-server --skip-broken

启动MySQL服务器

shell> sudo service mysqld status

或

shell> sudo systemctl status mysqld.service # el7首选命令

刚安装好的MySQL会为root用户创建临时密码，查看方式如下：

$ grep 'password' /var/log/mysqld.log |head -n 1

"2018-03-30T15:25:58.108397Z 1 [Note] A temporary password is generated for root@localhost: [I3ppFewwa:xv] "

查看该文件位置

mysql> select @@log_error;

查看临时密码

grep 'password' /var/log/mysqld.log |head -n 1

使用临时密码登入MySQL并修改root密码

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

错误提示：密码设置不符合要求

Your password does not satisfy the current policy requirements

使用validate_password插件设置密码状态

mysql> set global validate_password_policy=0; # 调整安全级别

mysql> set global validate_password_length = 6; # 设置密码默认长度

查看该插件是否安装，MySQL5.7默认安装

$ SHOW VARIABLES LIKE 'validate_password%';