Centos7.3服务器mysql安装与配置_centos7.3 mysql服务器地址-CSDN博客

本文链接：https://blog.csdn.net/qq_33768809/article/details/98944089

配置yum源
1.下载mysql源安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

##如果报错-bash: wget: command not found的话安装wget

yum -y install wget

2.安装mysql源

yum localinstall mysql57-community-release-el7-8.noarch.rpm

3.检查mysql源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

安装成功结果

[root@iZ8vbe3n0yb60d2flayh2kZ local]# yum repolist enabled | grep "mysql.*-community.*"
mysql-connectors-community/x86_64 MySQL Connectors Community                 118
mysql-tools-community/x86_64      MySQL Tools Community                       95
mysql57-community/x86_64          MySQL 5.7 Community Server                 364

安装mysql
```
yum install mysql-community-server
```
在这过程中会询问的都按y然后回车允许

启动MySQL服务

1.启动mysql服务

systemctl start mysqld

2.查看mysql状态

systemctl status mysqld

在这里插入图片描述 3.设置MySQL开机启动

systemctl enable mysqld
systemctl daemon-reload

修改root默认密码
1.找到root默认密码
```
grep 'temporary password' /var/log/mysqld.log
```
2.进入mysql控制台
```
mysql -uroot -p
```
3.修改密码

用该密码登录到服务端后，必须马上修改密码，不然会报错误
最新mysql要求密码必须包含大小写字母和字符，长度大于等于8个字符
```
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root123!';
```
修改mysql参数设置任意密码
首先，修改validate_password_policy参数的值
```
mysql> set global validate_password_policy=0; 
```
再修改密码的长度
```
mysql> set global validate_password_length=1;
```
再次修改密码
```
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
```
4.授权远程登录
```
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
```
5.立即生效
```
mysql> flush privileges;
```
6.退出
```
mysql> exit
```

防火墙设置

查看状态：firewall-cmd --state
开启：systemctl start firewalld
开放端口：firewall-cmd --permanent --zone=public --add-port=3306/tcp
重新载入防火墙规则：firewall-cmd --reload
检查是否生效：firewall-cmd --zone=public --query-port=3306/tcp