Linux下安装配置MySQL5.7 - 田小晖的博客

查看有没有安装mariadb
Terminal window
```
1
rpm -qa | grep mariadb
```
image-20200313185315913
有的话卸载 —nodeps是强制卸载不加可能会导致依赖检测失败
Terminal window
```
1
rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64
```
删除mariadb配置文件
Terminal window
```
1
rm -rf /etc/my.cnf*
```

下载MySQL源安装包

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

安装MySQL源

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

检查MySQL源是否安装成功
Terminal window
```
1
sudo yum repolist enabled | grep "mysql.*-community.*"
```
image-20200313185723031

安装MySQL

1
sudo yum install mysql-community-server

启动MySQL服务
Terminal window
```
1
sudo systemctl start mysqld
```

查看MySQL的启动状态

1
sudo systemctl status mysqld
2
#或者
3
sudo ps -le | grep mysqld

设置开机启动

1
sudo systemctl enable mysqld
2
sudo systemctl daemon-reload

修改 MySQL 中 root 本地登录密码

1
sudo grep 'temporary password' /var/log/mysqld.log
2
#如果没有grep出来 执行下面的操作
3
    #删除原来安装过的mysql残留的数据（这一步非常重要，问题就出在这）
4
    rm -rf /var/lib/mysql
5
    #重启mysqld服务 之后就会有了
6
    systemctl restart mysqld

登录MySQL，使用刚才找到的密码
Terminal window
```
1
mysql -u root -p
```

修改root用户密码（二选一）

1
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
2
set password for 'root'@'localhost'=password('MyNewPass4!');

修改密码策略修改完就可以改成简单密码了设置安全级别为LOW 密码长度为6
Terminal window
```
1
set global validate_password_policy=LOW;
2
set global validate_password_length=6;
```
注意：mysql5.7默认安装了密码安全检查插件（validate_password），默认密码检查策略要求密码必须包含：大小写字母、数字和特殊符号，并且长度不能少于8位。否则会提示ERROR 1819 (HY000): Your password does not satisfy the current policy requirements错误，如下图所示：

image-20200214171546386

通过msyql环境变量可以查看密码策略的相关信息
Terminal window
```
1
show variables like '%password%';
```

设置远程登录

1
#MySQL默认只允许root帐户在本地登录，想要远程连接MySQL，必须开启root用户允许远程连接，或者添加一个允许远程连接的帐户
2

3
#开启root用户远程连接（任意IP都可以访问）
4
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root用户的密码' WITH GRANT OPTION;
5
#开启root用户远程连接（指定192.168.110.120访问）
6
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.110.120' IDENTIFIED BY 'root用户的密码' WITH GRANT OPTION;
7
#安全起见， 创建远程访问用户
8
GRANT ALL PRIVILEGES ON *.* TO 'dadeity'@'%' IDENTIFIED BY '[email protected]' WITH GRANT OPTION;
9
#刷新MySQL的系统权限相关表，否则会出现拒绝访问
10
flush privileges;

MySQL设置

1
#设置MySQL默认编码为utf8
2
#修改 /etc/my.cnf配置文件 在[mysqld]下添加
3
character_set_server=utf8
4
init_connect='SET NAMES utf8'
5
#重启MySQL服务
6
systemctl restart mysqld
7
#查看MySQL默认编码如下
8
mysql> show variables like '%character%';
9
+--------------------------+----------------------------+
10
| Variable_name            | Value                      |
11
+--------------------------+----------------------------+
12
| character_set_client     | utf8                       |
13
| character_set_connection | utf8                       |
14
| character_set_database   | utf8                       |
15
| character_set_filesystem | binary                     |
16
| character_set_results    | utf8                       |
17
| character_set_server     | utf8                       |
18
| character_set_system     | utf8                       |
19
| character_sets_dir       | /usr/share/mysql/charsets/ |
20
+--------------------------+----------------------------+
21
8 rows in set (0.01 sec)
22

23
#默认配置文件路径
24
配置文件：    /etc/my.cnf
25
日志文件：    /var/log//var/log/mysqld.log
26
服务启动脚本： /usr/lib/systemd/system/mysqld.service
27
socket文件：  /var/run/mysqld/mysqld.pid
28

29
#查看MySQL版本
30
mysql> SHOW VARIABLES WHERE Variable_name = 'version';
31
+---------------+--------+
32
| Variable_name | Value  |
33
+---------------+--------+
34
| version       | 5.7.29 |
35
+---------------+--------+

MySQL忘记root用户密码，解决方案

1
#在 /etc/my.cnf文件[mysqld]下面加如下命令
2
skip-grant-tables
3
#指定登录 不要密码
4
mysql  -u root
5
#修改密码
6
update mysql.user set authentication_string=password('newPass') where user='root' and Host = 'localhost';
7
#刷新权限
8
flush privileges;
9

10
GRANT ALL PRIVILEGES ON *.* TO 'bewinner'@'10.25.60.120' IDENTIFIED BY 'BeWinner2020#@!' WITH GRANT OPTION;
11

12
GRANT ALL PRIVILEGES ON *.* TO 'bewinner_remote'@'114.251.40.124' IDENTIFIED BY 'BeWinner!!.' WITH GRANT OPTION;

音乐

音乐

文章分享