yum 安装mysql 5.7

下载

#1.下载安装官方yum repository

[root@localhost ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

安装

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

[root@localhost ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm

3.之后就开始安装MySQL服务器。修改yum源启动要安装的数据库

[root@localhost ~]# yum -y install mysql-community-server

4.启动mysql

[root@localhost ~]# systemctl start  mysqld.service
[root@localhost ~]# systemctl status mysqld.service

密码

5.查看密码

[root@localhost ~]# grep "password" /var/log/mysqld.log

6.进入数据库修改密码
[root@localhost ~]# mysql -uroot -p
输入初始密码，此时不能做任何事情，因为MySQL默认必须修改密码之后才能操作数据库：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '1234';

查看初始密码规则
mysql> SHOW VARIABLES LIKE 'validate_password%';
允许弱密码的存在
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;

7.卸载掉自动更新

[root@localhost ~]# yum -y remove mysql57-community-release-el7-10.noarch

8.允许远程登陆
查看权限

mysql> select host,user,password from user;
#mysql> select host,user,authentication_string from user 密码字段可能不一样。
授权
mysql> update user set host = '%' where user = 'root';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 
mysql -urepl -h192.168.1.11 -P3306  -p1234    #指定端口号