mysql数据库安装环境部署

た入场券 2022-03-20 13:58 242阅读 0赞

**1、安装环境**

系统：linux

工具：mysql-8.0.15-1.el7.x86\_64.rpm-bundle.tar，下载地址：官网，[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]

**2、安装步骤**

1）上传本地mysql-8.0.15-1.el7.x86\_64.rpm-bundle.tar文件到指定的服务器目录/root/tools

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70][]

2）解压mysql-8.0.15-1.el7.x86\_64.rpm-bundle.tar上传文件，tar -xvf mysql-8.0.15-1.el7.x86\_64.rpm-bundle.tar

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 1][]

3）解决依赖关系，yum remove mysql-libs

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 2][]

4）客户端，rpm -ivh mysql-community-client-8.0.15-1.el7.x86\_64.rpm

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 3][]

5）公共模块，rpm -ivh mysql-community-common-8.0.15-1.el7.x86\_64.rpm

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 4][]

6）libs模块，rpm -ivh mysql-community-libs-8.0.15-1.el7.x86\_64.rpm

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 5][]

7）服务模块，rpm -ivh mysql-community-server-8.0.15-1.el7.x86\_64.rpm

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 6][]

8）查看服务状态，service mysqld status

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 7][]

**3、root用户密码修改与开通远程访问权限**

1）my.cnf配置文件中，添加skip-grant-tables标记，开启免密登陆。vi /etc/my.cnf

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 8][]

2）重启mysql服务，service mysqld restart

![20190213145529416.png][]

3）免密登陆mysql服务器，mysql -u root -p，此时不需要输入密码。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 9][]

4）数据库切换到mysql管理库，use mysql。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 10][]

5）更新root用户数据信息

update user set host='%' where user='root';

flush privileges;

ALTER user 'root'@'%' IDENTIFIED BY 'root\#2019';

flush privileges;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 11][]

6）my.cnf配置文件中，删除skip-grant-tables标记，关闭免密登陆。vi /etc/my.cnf

7）重启mysql服务，service mysqld restart

**4、外部链接数据库**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 12][]

如果遇到不能访问，请参考：[https://blog.csdn.net/zhangqiang\_accp/article/details/86707274][https_blog.csdn.net_zhangqiang_accp_article_details_86707274] 文章模块的防火墙处理。

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70]: /images/20220320/2980d7bc210f45ce93c0f5ca998922a1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 1]: /images/20220320/c0347e918259449088b6a9e714d65c74.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 2]: /images/20220320/d3c799aa16d743b6bf0bc36d514c82b5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 3]: /images/20220320/7fd2104a30e1401fa59c15d4c1442001.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 4]: /images/20220320/9d4d81bbbe4447c48613a7608c1087fa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 5]: /images/20220320/4c7f48cdfb1b4bdc92ddd3e6cca631f0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 6]: /images/20220320/963038e0130c48e5889af32177e1a344.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 7]: /images/20220320/da88ebaacb164279a0468b3fcb315a90.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 8]: /images/20220320/387d8817c5b940cfaeea9adf65e7bc5a.png
[20190213145529416.png]: /images/20220320/d5e9e4cafd8a44ada5084e9b991f84cb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 9]: /images/20220320/53b9750cfe524a4480f79ba9bca5fa79.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 10]: /images/20220320/53fce0e09212453e98ad11ca13c98fd9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 11]: /images/20220320/7ba00d32c92342f08e7d031f608c68e1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncWlhbmdfYWNjcA_size_16_color_FFFFFF_t_70 12]: /images/20220320/d070eb683d9f41d38a93d4c97a4e2462.png
[https_blog.csdn.net_zhangqiang_accp_article_details_86707274]: https://blog.csdn.net/zhangqiang_accp/article/details/86707274