CentOS 7 安装 MySQL5.7

CentOS版本：CentOS Linux release 7.5.1804 (Core)

MySQL版本：mysql57-community-release-el7-9

1、下载并安装MySQL

[root@localhost local]# wget http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

[root@localhost local]# yum localinstall mysql57-community-release-el7-9.noarch.rpm

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

2、启动MySQL并设置自起

[root@localhost local]# systemctl start mysqld
[root@localhost local]# systemctl enable mysqld
[root@localhost local]# systemctl daemon-reload

3、获取MySQL的临时密码

[root@localhost local]# grep 'temporary password' /var/log/mysqld.log

如：2018-07-26T08:46:21.703543Z 1 [Note] A temporary password is generated for root@localhost: WR_phiBkD2of

4、使用临时密码登录MySQL

[root@localhost local]# mysql -u root -p
Enter password:

登录成功

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.22

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

5、修改登录密码

mysql> set global validate_password_policy=0;  //设置密码策略
Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password_length=6;  //设置密码位数
Query OK, 0 rows affected (0.00 sec)

mysql> set password = password('123456');      //设置密码
Query OK, 0 rows affected, 1 warning (0.00 sec)

6、创建远程连接

//创建用户、密码及权限范围第一个root为用户名@后为适用的主机，'%'表示所有电脑都可以访问连接，第二个root为密码
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;          //立即生效
Query OK, 0 rows affected (0.00 sec)

7、查看可连接设备及端口号

mysql> use mysql;                 //使用mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT DISTINCT CONCAT('User: [', user, '''@''', host, '];') AS USER_HOST FROM user; 
+------------------------------------+
| USER_HOST                          |
+------------------------------------+
| User: [root'@'%];                  |
| User: [mysql.session'@'localhost]; |
| User: [mysql.sys'@'localhost];     |
| User: [root'@'localhost];          |
+------------------------------------+
4 rows in set (0.00 sec)

mysql> show global variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3306  |
+---------------+-------+
1 row in set (0.00 sec)

附录：

1、密码策略

Policy	Tests Performed
0 or LOW	Length
1 or MEDIUM	Length; numeric, lowercase/uppercase, and special characters
2 or STRONG	Length; numeric, lowercase/uppercase, and special characters; dictionary file