CentOS中安装MySQL数据库

桃扇骨 2022-05-26 02:53 201阅读 0赞

**1)       配置YUM源  
（1）在MySQL官网中下载YUM源rpm安装包：**  
[**https://dev.mysql.com/downloads/repo/yum/**][https_dev.mysql.com_downloads_repo_yum]  
**（2）单击下载Linux7的mysql57的rpm  
![70][]  
（3）复制下载地址  
![70 1][]  
（4）下载mysql源安装包：wget** [**https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm**][https_repo.mysql.com_mysql57-community-release-el7-11.noarch.rpm]  
**![70 2][]  
（5）安装mysql源：yum localinstall mysql57-community-release-el7-11.noarch.rpm  
![70 3][]  
![70 4][]  
（6）检查mysql源是否安装成功：yum repolist enabled | grep mysql  
![70 5][]**

**2)       安装MySQL：yum install mysql-community-server  
![70 6][]  
![70 7][]**

**3)       启动MySQL服务：systemctl start mysqld；查看MySQL的启动状态：systemctl status mysqld  
![70 8][]**

**4)       开机启动：shell> systemctl enablemysqld   shell> systemctldaemon-reload  
![70 9][]**

**5)       修改root本地登录密码  
（1）查看密码\--mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码  
grep 'temporary password'/var/log/mysqld.log  
![70 10][]  
（2）用该默认密码登录MySQl  
![70 11][]  
（3）修改密码: ALTER USER'root'@'localhost' IDENTIFIED BY 'HouFengfei@668';  
![70 12][]**

**6)       用Navicat连接centos中的MySQL数据库  
（1）进入MySQL命令行，允许所有主机访问centos的MySQL  
![70 13][]  
grant select, update, delete, create onPICARRO.\* to root@192.168.248.133 identified by 'HouFengfei@668';  
![70 14][]  
（2）关闭firewalld防火墙，或者开发3306端口  
（3）用Navicat进行连接  
![70 15][]**

[https_dev.mysql.com_downloads_repo_yum]: https://dev.mysql.com/downloads/repo/yum/
[70]: /images/20220526/e1ffbe34ab614591a04c4c42cf8bfeaf.png
[70 1]: /images/20220526/ebeb5a440276474cbcc4428c833cf6c5.png
[https_repo.mysql.com_mysql57-community-release-el7-11.noarch.rpm]: https://repo.mysql.com/mysql57-community-release-el7-11.noarch.rpm
[70 2]: /images/20220526/421ea567827043ca8fe32abc0edfb9af.png
[70 3]: /images/20220526/e4ae699d03f44db18035c22b11b5d77b.png
[70 4]: /images/20220526/6c44bd2660f649bf8bf1cb885d912998.png
[70 5]: /images/20220526/511b767059f34171adba319891f9ec28.png
[70 6]: /images/20220526/be23f6b6f08342649efc052882ca5f84.png
[70 7]: /images/20220526/7d2b13b1f22240fdbb9eaeac983ba636.png
[70 8]: /images/20220526/2495ee1fd5aa48bbaf904dc130c8c96f.png
[70 9]: /images/20220526/79dc24665ec640c395639088480950d0.png
[70 10]: /images/20220526/d068b9b8d9204523adbeed56c05f658e.png
[70 11]: /images/20220526/8fc83fc4651f4f0da298b22efce4f635.png
[70 12]: /images/20220526/3c9d6eccaa9c4ad58d2d26fa46fb0c3c.png
[70 13]: /images/20220526/e788784f99ed46f3a80799f9cb4e0013.png
[70 14]: /images/20220526/3742fbd3c9434527a85e8672e49a9ae9.png
[70 15]: /images/20220526/993c154f7b1c4f458330d0daf6fd6a86.png