部署MySQL5.7.17数据库服务器

柔情只为你懂 2022-04-22 03:14 62阅读 0赞

1、从mysql官网下载mysql-5.7.17的tar包  
（mariadb和mysql只能有一个，因为都是3306端口）

2、tar解包并查看内容

[root@mysql databases]# ls

mysql-5.7.17.tar

[root@mysql databases]# tar -xf mysql-5.7.17.tar 
    [root@mysql databases]# ls

mysql-5.7.17.tar  
mysql-community-client-5.7.17-1.el7.x86\_64.rpm  
mysql-community-common-5.7.17-1.el7.x86\_64.rpm  
mysql-community-devel-5.7.17-1.el7.x86\_64.rpm  
mysql-community-embedded-5.7.17-1.el7.x86\_64.rpm  
mysql-community-embedded-compat-5.7.17-1.el7.x86\_64.rpm  
mysql-community-embedded-devel-5.7.17-1.el7.x86\_64.rpm  
mysql-community-libs-5.7.17-1.el7.x86\_64.rpm  
mysql-community-libs-compat-5.7.17-1.el7.x86\_64.rpm  
mysql-community-minimal-debuginfo-5.7.17-1.el7.x86\_64.rpm  
mysql-community-server-5.7.17-1.el7.x86\_64.rpm  
mysql-community-test-5.7.17-1.el7.x86\_64.rpm  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dnd19kcmVhbQ_size_16_color_FFFFFF_t_70]

3、yum安装rpm包

[root@mysql databases]# yum -y install   mysql-community-*.rpm

\#\#依赖包 perl-JSON.noarch.0.2.59-2.el7 自动安装 \\yum自动解决依赖包

![在这里插入图片描述][20181101202313124.png]  
![在这里插入图片描述][2018110120232476.png]

4、查看mysqsl配置文件

[root@mysql databases]# vim /etc/my.cnf

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dnd19kcmVhbQ_size_16_color_FFFFFF_t_70 1]

4、启动服务、查看进程

`[root@mysql databases]# systemctl start mysqld` 启动服务  
`[root@mysql databases]# ss -nutplea | grep :3306` ss-nutpla查看进程 \\grep :3306查找3306端口

![在这里插入图片描述][20181101203735283.png]

5、初始密码登陆（每一台的初始密码都不一样）

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

2018-11-06T01:33:10.324989Z 1 \[Note\] A temporary password is generated for root@localhost: ?9IS=DM?yQ-w

?9IS=DM?yQ-w     //这个就是初始密码

![在这里插入图片描述][20181106093630468.png]

[root@mysql ~]# mysql -uroot -p?9IS=DM?yQ-w

mysql: \[Warning\] Using a password on the command line interface can be insecure.  
Welcome to the MySQL monitor. Commands end with ; or \\g.  
Your MySQL connection id is 3  
Server version: 5.7.17

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>

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dnd19kcmVhbQ_size_16_color_FFFFFF_t_70 2]

5、修改密码策略

修改全局变量要加global  
mysql内的命令后要加 " ; "

初始密码进入后先修改密码，退出在用修改的密码登陆后才有权限  
`mysql>set global validate_password_policy=0;` //只验证长度  
Query OK, 0 rows affected (0.00 sec)  
`mysql>set global validate_password_length=6；` //修改密码长度,默认值是8个字符  
Query OK, 0 rows affected (0.00 sec)  
`mysql> alter user user() identified by "123456";` //修改登陆密码  
Query OK, 0 rows affected (0.00 sec)

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dnd19kcmVhbQ_size_16_color_FFFFFF_t_70]: /images/20220422/44ed4a1dce0d4e9aafb09fad898aedcf.png
[20181101202313124.png]: /images/20220422/f33fc1172ede454fa93cf6f24165655c.png
[2018110120232476.png]: /images/20220422/b0b5f0d67a5b49039f76e4907882a564.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dnd19kcmVhbQ_size_16_color_FFFFFF_t_70 1]: /images/20220422/b3fc039b85884998abe374b0a2b823f1.png
[20181101203735283.png]: /images/20220422/23451e1afa2b4b7aa0d2bbd619400181.png
[20181106093630468.png]: /images/20220422/73b489fd104b45b0834075b8628a7acd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dnd19kcmVhbQ_size_16_color_FFFFFF_t_70 2]: /images/20220422/935fa7a04c7a4061abb89f35e1b44d7f.png