CentOS7安装Mysql并运行SpringBoot项目

￡神魔★判官ぃ 2022-02-20 03:57 303阅读 0赞

**前言：本次安装通过yum安装Mysql**

**SpringBoot项目是自己以前写过的。（没有经验的朋友，可以仅仅学习一下如何yum安装Mysql）**

**SpringBoot项目资源和Linux帮助文档请戳-->  链接：https://pan.baidu.com/s/1-r8hhj\_Mt5QvVylWy4h1vg  提取码：ydwr **

**如何安装JDK/Tomcat/Maven?请戳☞ **[https://blog.csdn.net/CCIEJohn\_zhou/article/details/89204749][https_blog.csdn.net_CCIEJohn_zhou_article_details_89204749]

**一.yum安装Mysql**

**1.1查看自带的yum仓库**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70][]  
**1.2下载Mysql的repo源**

**指令：wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 1][]

**问题**：*有时爬取请求会被拒绝，换个网络试试一般可以解决。*

![20190412153511798.png][]

**1.3安装repo的源**

**指令：rpm -ivh mysql-community-release-el7-5.noarch.rpm**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 3][]

**1.4yum安装Mysql**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 4][]

**1.5检查是否安装成功**

**指令：rpm -qa|grep mysql**

![20190412155331701.png][]

**1.6开启mysql服务**

**指令：service mysql start**

![20190412155634857.png][]

**1.7修改Mysql数据库的编码格式为UTF-8**

*登录*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 5][]

*查看status*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 6][]

*进入/etc/my.cnf*

![20190412160237352.png][]

*修改配置信息*

![20190412160621361.png][]

*重启Mysql服务*

![2019041216083036.png][]

*再次查看status*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 7][]

**1.8修改Mysql数据库root用户密码**

*进入mysql数据库*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 8][]

*查看user表*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 9][]

*修改root用户密码*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 10][]

**最后: service mysql restart 重启Mysql服务，后面就需要用密码登录root用户了。**

**\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*到此为止，Mysql安装完成\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**小试牛刀：使用Mysql运行SpringBoot项目**

**二.运行SpringBoot项目**

**2.1 用Xftp导入SpringBoot项目和配套的sql文件**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 11][]

2.2 Mysql中新建数据库并导入sql文件

![20190412163954153.png][]

**2.3开放80端口：**

**指令：firewall-cmd  --zone=public  --add-port=80/tcp --permanent  //永久开放80端口 **

**指令：firewall-cmd --reload  //刷新防火墙配置文件**

![20190412170702536.png][]

**2.4 修改SpringBoot项目中连接数据库的配置信息。**

**vi  application.properties  //修改SpringBoot项目中的配置文件  位置：src/main/resources 下**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 12][]

**进入到项目文件夹输入Maven指令：  mvn  clean package   //清除旧target包并重新打包 **

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 13][]

**最后运行项目：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 14][]![20190412172810364.png][]

**访问：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 15][]

**拓展：用本地自定义域名访问项目  ---->  修改HOSTS文件   //用管理员模式修改**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 16][]

![20190412173848797.png][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 17][]

[https_blog.csdn.net_CCIEJohn_zhou_article_details_89204749]: https://blog.csdn.net/CCIEJohn_zhou/article/details/89204749
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70]: /images/20220220/6f5c2d2c75584f41ba0e74c28a04b89b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 1]: /images/20220220/720e937f1f174ae8b323edbc3e0013d0.png
[20190412153511798.png]: /images/20220220/215f8f3235fe4252a1624f16cc60db29.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 2]: /images/20220220/37a5212ae5d2486ea65192cc21d569fa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 3]: /images/20220220/12b0c8366231470db32daba0a0e6514b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 4]: /images/20220220/b010ad1b9ebf41639d60b8a3270ec0f1.png
[20190412155331701.png]: /images/20220220/19b20c1b87b84f1e872ff1ed7c07b342.png
[20190412155634857.png]: /images/20220220/0a9f1b5dce0f4f3c82ef1f6187b18bdb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 5]: /images/20220220/5b3cddf91625407bb579ee411b1fdffb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 6]: /images/20220220/d512fdd783094b878335da13d7b1c728.png
[20190412160237352.png]: /images/20220220/73014faf495444179a3720bc41fc909e.png
[20190412160621361.png]: /images/20220220/ad38338a7bc6480eb4c134745e64f1a0.png
[2019041216083036.png]: /images/20220220/a45576cf01794337a36b1546e4937311.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 7]: /images/20220220/595fed28a0a64a0c985da8e5c08cdc19.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 8]: /images/20220220/c5e514b54c884c1e9fb138dae0ae4ab1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 9]: /images/20220220/065907d039ed4faea5a950721599d35f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 10]: /images/20220220/ed370a34ec184b2e94631ca430c3d91b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 11]: /images/20220220/8d885c00b5024030bb8fcd75c46b2a28.png
[20190412163954153.png]: /images/20220220/a0afc999a2f147fc95235624f34f3245.png
[20190412170702536.png]: /images/20220220/a26addd1b47e4fbb913543b2f5ec1be4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 12]: /images/20220220/a08910dd359e4d7095aa80bb44a1a7c7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 13]: /images/20220220/c065cc320404406da016751532e46708.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 14]: https://img-blog.csdnimg.cn/20190412170221833.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U=,size_16,color_FFFFFF,t_70
[20190412172810364.png]: /images/20220220/766368c7229a43ac80dd989f814c4e62.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 15]: /images/20220220/8ae16a6e69ba4412b536ec5415e8cfcd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 16]: /images/20220220/9d48f98ad214445281e1744d40accadd.png
[20190412173848797.png]: https://img-blog.csdnimg.cn/20190412173848797.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDSUVKb2huX3pob3U_size_16_color_FFFFFF_t_70 17]: /images/20220220/3cadbe01599a4e328e866d6d68f7f672.png