【六】VirtualBox Centos7 安装 MySQL

红太狼 2021-10-14 00:58 558阅读 0赞

准备：

*  VirtualBox
 *  Centos7
 *  MySQL 5.7

1、从 MySQL 官网下载，`mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar`，

tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar -C mysql-5.7 # 解压

解压的文件：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppYW9idWNob25n_size_16_color_FFFFFF_t_70]  
2、 执行命令安装：

yum install mysql-community-{ server,client,common,libs}-* mysql-5.*

配置文件在：`/etc/my.cnf`。

3、启动 mysql 服务：

systemctl start mysqld

4、设置 root 密码

mysql -uroot -p 
    mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'your password'; # 修改root密码

设置密码的时候有可能出现：

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

这是 mysql 密码策略的问题，

show variables like 'validate_password%';  # 查看密码策略
    set global validate_password_policy=LOW;   # 修改密码策略

参考：[ERROR 1819 (HY000): Your password does not satisfy the current policy requirements][ERROR 1819 _HY000_ Your password does not satisfy the current policy requirements]

5、远程登录  
5.1 关闭防火墙  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppYW9idWNob25n_size_16_color_FFFFFF_t_70 1]  
如果有报上面这个错，执行命令关闭防火墙：

systemctl stop firewalld.service

参考：[centOS7永久关闭防火墙(防火墙的基本使用)][centOS7]

5.2 让 MySQL 允许远程登录  
继续使用 `Navicat Premium` 访问出现如下错误：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppYW9idWNob25n_size_16_color_FFFFFF_t_70 2]  
登录 mysql 修改配置：

mysql> use mysql
    mysql> select host from user where user = 'root';
    +-----------+
    | host      |
    +-----------+
    | localhost |
    +-----------+
    1 row in set (0.00 sec)
    mysql> update user set host = '%' where user = 'root';
    mysql> FLUSH PRIVILEGES;
    mysql>

参考：[Host is not allowed to connect to this MySQL server解决方法][Host is not allowed to connect to this MySQL server]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppYW9idWNob25n_size_16_color_FFFFFF_t_70]: /images/20211013/fc9295d28a794c79ac99df43e9a0a12f.png
[ERROR 1819 _HY000_ Your password does not satisfy the current policy requirements]: https://blog.csdn.net/hello_world_qwp/article/details/79551789
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppYW9idWNob25n_size_16_color_FFFFFF_t_70 1]: /images/20211013/e6d50ad7c01940d498e8efa84ea70ca1.png
[centOS7]: https://blog.csdn.net/shubingzhuoxue/article/details/84578749
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppYW9idWNob25n_size_16_color_FFFFFF_t_70 2]: /images/20211013/e764e8abbc494302b9fb69d8776e2c69.png
[Host is not allowed to connect to this MySQL server]: https://blog.csdn.net/bingjianit/article/details/54384299