Centos8.2安装mysql8

客官°小女子只卖身不卖艺 2022-12-11 12:25 201阅读 0赞

系统: CentOS 8.2

安装：mysql-8.0

rpm [https://dev.mysql.com/downloads/repo/yum/][https_dev.mysql.com_downloads_repo_yum]

[https://dev.mysql.com/downloads/file/?id=489467][https_dev.mysql.com_downloads_file_id_489467]

**下载并安装MySQL**

wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

下载到指定位置后，就可以执行安装了

yum install -y  mysql80-community-release-el8-1.noarch.rpm
    yum module disable mysql
    yum -y install mysql-community-server

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70][]

systemctl start  mysqld
    systemctl status  mysqld

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 1][]

查看MySQL是不是开机自启，可以执行命令查看开机自启列表

systemctl list-unit-files|grep enabled | grep mysql

此时如果要进入MySQL得找出root用户的密码，输入命令

grep "password" /var/log/mysqld.log

![20200930213744679.png][]

得到密码后，登录mysql，输入命令

mysql -uroot -p

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 2][]

此时，你需要给你的MySql重新设置密码，因为MySQL默认的就是必须修改密码后才能操作数据库。

![20200930214208894.png][]

总之呢，我们先将密码设置成比较复杂的就好,比如 Abc@123...，先登录了再说。

如果想要设置简单好记的密码，可以修改密码设置规范，毕竟你不登录你就不能修改规范。

查看密码规范

SHOW VARIABLES LIKE 'validate_password%';

密码的长度是由validate_password_length决定的，而validate_password_length的计算公式是：
    validate_password_length = validate_password_number_count + validate_password_special_char_count + (2 * validate_password_mixed_case_count)

这时候我们将密码设置规范修改一下：

set global validate_password.policy=0;
    set global validate_password.length=1;

use mysql;
    select user,host,grant_priv from user;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 3][]

![20200930215652552.png][]

更新授权数据库：

update user set grant_priv='Y' where user='root';
    flush privileges;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 4][]

现在就能给用户赋予权限了

允许远程连接：

GRANT ALL ON *.* TO 'root'@'%';

如果使用客户端连接提示了plugin caching\_sha2\_password错误，这是因为MySQL8.0的密码策略默认为caching\_sha2\_password

使用命令修改策略

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'wtl199201180271';

[https_dev.mysql.com_downloads_repo_yum]: https://dev.mysql.com/downloads/repo/yum/
[https_dev.mysql.com_downloads_file_id_489467]: https://dev.mysql.com/downloads/file/?id=489467
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70]: /images/20221123/43721c696cd44fa682d2f9bd9a5b1b9d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 1]: /images/20221123/6801bea841f5417ab4a75caf8c3ac69e.png
[20200930213744679.png]: /images/20221123/89adc6d4d1e546b7b822facdd9077371.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 2]: /images/20221123/fd25ac0465c84276b08bd56b39c3cc59.png
[20200930214208894.png]: /images/20221123/22c32b38ce13446bbd65ce7dc6bdc475.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 3]: /images/20221123/4413c631313d4425993cc7d626d7e3b9.png
[20200930215652552.png]: /images/20221123/7b7bc521baaf4e95af59a8d0a45f7776.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 4]: /images/20221123/3cbd0aed371c4a4f9c276bda416a7435.png