CentOS7.4用yum安装并配置MySQL5.7

偏执的太偏执、 2021-12-21 08:47 294阅读 0赞

## 1、配置YUM源 ##

下载MySQL源安装包

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

安装MySQL源

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

检查MySQL源是否安装成功

yum repolist enabled | grep “mysql.-community.”

![1404518-20190410105027052-162882054.png][]

## 2、安装MySQL ##

yum install mysql-community-server

出现以下表示安装成功：

rpm -qa | grep mysql，查看都安装了那些包

![1404518-20190410073934747-711674357.png][]

## 3、启动MySQL服务 ##

systemctl start mysqld

查看MySQL的启动状态

systemctl status mysqld

![1404518-20190410074153400-1072830460.png][]

开机启动

systemctl enable mysqld

重载所有修改过的配置文件

systemctl daemon-reload

## 4、查看MySQL下root账号的默认密码 ##

mysql5.7安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码，然后登录MySQL。

命令：grep 'temporary password' /var/log/mysqld.log

![1404518-20190410074828693-55392361.png][]

可以看到默认的密码是：<4d&do\#k5V&f

用默认密码进到MySQL数据库是不能操作的，需要修改root密码

![1404518-20190410103022834-145793069.png][]

## 5、先修改配置文件，后设置密码 ##

默认配置文件路径

配置文件：/etc/my.cnf

日志文件：log-error=/var/log/mysqld.log

服务启动脚本：/usr/lib/systemd/system/mysqld.service

socket文件：socket=/var/lib/mysql/mysql.sock

修改my.cnf文件

修改密码策略

mysql的密码策略分为三种：

0或LOW：Length

1或MEDIUM：Length; numeric, lowercase/uppercase, and special characters

2或STRONG：Length; numeric, lowercase/uppercase, and special characters; dictionary file

在my.cnf配置文件中增加如下设置

如果不需要密码策略，禁用密码策略

validate\_password = off

密码选择策略 0-LOW，1-MEDIUM，2-STRONG需要提供密码字典文件

validate\_password\_policy = 0

修改字符编码为utf8

在\[mysqld\]下增加如下配置

character\_set\_server = utf8

init\_connect = ‘SET NAMES utf8’

![1404518-20190411084822596-1250714858.png][]

保存my.cnf配置文件并重启mysql服务使配置生效

systemctl restart mysqld

登录MySQL

mysql -u root -p

输入密码：默认为刚才查到的密码"<4d&do\#k5V&f"

## 6、修改密码步骤如下： ##

alter user 'root'@'localhost' identified by '123456';

grant all privileges on \*.\* to 'root' @'%' identified by 'yourpassword';   \# 允许远程访问MySQL

刷新权限

flush privileges;

重新登录MySQL

mysql -u root -p

输入刚设置的密码"123456"即可登录进MySQL

## 7、查看设置的字符集 ##

show variables like "%character%";show variables like "%collation%";

![1404518-20190410103847840-696401265.png][]

转载于:https://www.cnblogs.com/opsprobe/p/10681063.html

[http_dev.mysql.com_get_mysql57-community-release-el7-8.noarch.rpm]: http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
[1404518-20190410105027052-162882054.png]: /images/20211221/3639dd2750ce493d82bb995a0635c692.png
[1404518-20190410073934747-711674357.png]: /images/20211221/2a68e8fdafea4583b95e84a397db0e1b.png
[1404518-20190410074153400-1072830460.png]: /images/20211221/687c9345400e4779a66526e7e65dc7d0.png
[1404518-20190410074828693-55392361.png]: /images/20211221/a89d1c01c1fa43e9a1e53a6bc52431dd.png
[1404518-20190410103022834-145793069.png]: /images/20211221/aa11e6b51fbc4d4688ac3fd3a23b2b3f.png
[1404518-20190411084822596-1250714858.png]: /images/20211221/566fa604b40545f1ab9ea236b02d00b4.png
[1404518-20190410103847840-696401265.png]: /images/20211221/450fc2087e1f4cf59568a7d4e2261541.png