数据库mysql5.7 rpm安装（无网络安装）

Centos7安装mysql5.7数据库（无网模式安装）

1. cd /usr/local/src/                                                                   #进入/usr/local/src

2.通过xftp软件上传mysql-5.7.10-el7.x86_64.rpm-bundle.tar

3.tar xvf mysql-5.7.10-el7.x86_64.rpm-bundle.tar                 #解压安装包

4. yum remove mariadb-libs -y                                                 #卸载mariadb-libs包

5.mkdir mysql                                                                             #创建mysql文件夹

4.mv

mysql-community-client-5.7.10-el7.x86_64.rpm

mysql-community-server-5.7.10-1.el7.x86_64.rpm

mysql-community-common-5.7.10-1.el7.x86_64.rpm

mysql-community-libs-5.7.10-1.el7.x86_64.rpm mysql/  #把相关mysql数据库移到mysql文件夹

5.cd mysql  &&  ls                                                                                   #进入mysql文件夹并查看

6. rpm -ivh mysql-community-common-5.7.10-1.el7.x86_64.rpm        #安装common包

7. rpm -ivh mysql-community-libs-5.7.10-1.el7.x86_64.rpm                  #安装lib包

8. rpm -ivh mysql-community-client-5.7.10-1.el7.x86_64.rpm              #安装客户端

9. rpm -ivh mysql-community-server-5.7.10-1.el7.x86_64.rpm             #安装server端

10. systemctl start mysqld.service                                                    #启动mysql服务

11. systemctl status mysqld.service                                                  #查看mysql服务状态

12.grep 'temporary password' /var/log/mysqld.log                        #查看数据库初始密码

13.mysql  -uroot  -p$password                                                                      #登陆数据库

14.mysql>set password = password('1!qQ1111');                                           #修改密码

 

15.mysql> show databases;                                              #查看库确保没问题；

16.mysql>\q                                                                       #退出数据库

17.vi /etc/my.cnf

[mysqld]

validate_password=off                                     #密码复杂度改为off

character_set_server=utf8                               #字符集设置为utf8

lower_case_table_names=1                             #开启区分大小写功能

18.然后保存并退出

19. systemctl restart mysqld                                     #重启mysql服务

20. systemctl status mysqld                                      #查看mysql状态