centos下安装mysql7图文教程

女爷i 2023-10-18 09:16 82阅读 0赞

**1、centos7系统自带mariadb数据库，先卸载再安装mysql,防止有冲突。**  
1） 查询是否有安装的mariadb文件  
rpm -qa | grep mariadb  
![在这里插入图片描述][70]  
2）使用-nodeps 不考虑依赖，强制卸载  
rpm -e --nodeps mariadb-server-5.5.56-2.el7.x86\_64  
rpm -e --nodeps mariadb-server-5.5.56-2.el7.x86\_64  
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86\_64

**2、下载MySQL官方的 Yum Repository**  
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm  
yum -y install mysql57-community-release-el7-11.noarch.rpm  
安装结束会看到 complete！

下面就开始安装mysql服务器  
yum -y install mysql-community-server

**mysql配置**  
启动数据库  
systemctl start mysqld.service  
或  
service mysqld start

输入命令查看mysql运行状态  
systemctl status mysqld.service \#检查mysql服务状态  
![在这里插入图片描述][0cd1e8279c41c4afacdd71684eb79871.png]

在日志文件中找出此时root用户临时密码：  
grep “password” /var/log/mysqld.log  
![在这里插入图片描述][2d7fdd9759310f5b29f30b5c6ebdb0ee.png]  
（红色框出来的就是临时密码）

登陆mysql：  
mysql -uroot -p  
![在这里插入图片描述][e86c4307b538cc38e9fe8807f383ebbc.png]

必须先输入这两条命令才能修改数据库登录密码：  
mysql> set global validate\_password\_policy=0;  
mysql> set global validate\_password\_length=1;

修改root账号密码：  
update user set authentication\_string=password(‘123456’) where user=‘root’;

为root用户授权远程登陆：  
GRANT ALL PRIVILEGES ON *.* TO root@“%” IDENTIFIED BY “root”;  
flush privileges;  
查看表  
use mysql;  
select host,user from user;  
显示如下，表示已经可以远程连接。  
![在这里插入图片描述][70 1]  
重启mysql服务  
systemctl restart mysqld.service

开防火墙3306端口  
firewall-cmd --zone=public --add-port=3306/tcp --permanent  
service firewalld restart  
![在这里插入图片描述][70 2]![在这里插入图片描述][70 3]

进行到这里就可以进行远程连接测试了  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNTcwODc5_size_16_color_FFFFFF_t_70]

这是mysql的相关命令  
systemctl start mysqld.service \#启动mysql服务  
systemctl stop mysqld.service \#关闭mysql服务  
systemctl restart mysqld.service \#重启mysql服务  
systemctl status mysqld.service \#检查mysql服务状态  
mysql -V \#查看mysql版本

[70]: https://img-blog.csdn.net/20180927111758226?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNTcwODc5/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[0cd1e8279c41c4afacdd71684eb79871.png]: https://img-blog.csdnimg.cn/img_convert/0cd1e8279c41c4afacdd71684eb79871.png
[2d7fdd9759310f5b29f30b5c6ebdb0ee.png]: https://img-blog.csdnimg.cn/img_convert/2d7fdd9759310f5b29f30b5c6ebdb0ee.png
[e86c4307b538cc38e9fe8807f383ebbc.png]: https://img-blog.csdnimg.cn/img_convert/e86c4307b538cc38e9fe8807f383ebbc.png
[70 1]: https://img-blog.csdn.net/2018092715432499?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNTcwODc5/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 2]: https://img-blog.csdn.net/20180927154649791?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNTcwODc5/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 3]: https://img-blog.csdn.net/20180927154638904?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNTcwODc5/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNTcwODc5_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2018120413074020.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNTcwODc5,size_16,color_FFFFFF,t_70