centos 安装mysql8，配置root远程登陆, mysql忘记密码

墨蓝 2023-06-29 10:36 21阅读 0赞

### 文章目录 ###

*  1, yum安装mysql8
 *   *   *  mysql安装：设置初始化密码+密码文件
     *  忘记root密码
     *  设置密码文件，免密登录mysql
 *  2，配置root远程登录

# 1, yum安装mysql8 #

配置yum源: [https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html][https_dev.mysql.com_doc_refman_8.0_en_linux-installation-yum-repo.html]

cat > /etc/yum.repos.d/mysql8.repo <<EOF #MySQL 8.0 [mysql80-community] name=MySQL 8.0 Community Server baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/\$basearch/ enabled=1 gpgcheck=0 #gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql EOF
    
    cat /etc/yum.repos.d/mysql8.repo
    sudo yum -y install mysql-community-server
    systemctl start  mysqld
    
    #1,获取随机生成的root密码
    #[root@c7 rpms]# cat /var/log/mysqld.log |grep "password"
    #2020-01-10T03:20:26.007171Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: dhwx+G;po5wk
    tmpass=$(cat b.txt |grep password |awk -F 'root@localhost: ' '{print $2}')
    
    #登录Mysql 
    mysql -uroot -p$tmpass

### mysql安装：设置初始化密码+密码文件 ###

mysql_root_pwd=test@123
    cat  > ~/.my.cnf <<EOF [client] user=root password=$mysql_root_pwd EOF
    #
    service mysqld start
    service mysqld stop
    sed  -i '/mysql/s@/bin/false@/bin/bash@' /etc/passwd
    #
    cat >/tmp/mysqlini.txt <<EOF uninstall plugin validate_password; ALTER USER 'root'@'localhost' IDENTIFIED BY '$mysql_root_pwd'; EOF
    #
    su mysql -c "mysqld --init-file=/tmp/mysqlini.txt & " &
    sleep 5
    mysql -e "show databases"

## 忘记root密码 ##

重设root密码: [https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html][https_dev.mysql.com_doc_refman_8.0_en_resetting-permissions.html]

# 方法1：(先关闭mysql服务)
    [root@c7 mysh]# sed -i '/mysql/s@/sbin/nologin@/bin/bash@' /etc/passwd
    [root@c7 mysh]# su mysql -c "mysqld --skip-grant-tables --skip-networking=on "
    #切换到另一个窗口，执行以下操作
    [root@c7 mysh]# mysql
    MariaDB [(none)]> update mysql.user set password=password('root') where user='root' AND Host = 'localhost';
    Query OK, 1 rows affected (0.00 sec)
    #
    #如果上述操作不行，就换下面这种通用办法
    mysql>UPDATE mysql.user SET authentication_string = PASSWORD('123456') WHERE User = 'root' AND Host = 'localhost';
    mysql>FLUSH PRIVILEGES;
    
    
    
    
    ##方法2：(先关闭mysql服务)
    [root@c7 mysh]# cat >/tmp/mysqlini.txt <<EOF
    UNINSTALL PLUGIN validate_password;
    ALTER USER 'root'@'localhost' IDENTIFIED BY 'XYZxyz123!';
    EOF
    [root@c7 mysh]# su mysql -c "mysqld --init-file=/tmp/mysqlini.txt "

## 设置密码文件，免密登录mysql ##

设置密码文件 [https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html][https_dev.mysql.com_doc_refman_5.7_en_password-security-user.html]

[root@test-c6 ~]# cat .my.cnf
    [client]
    user=root1
    password="JIDU+4kAZSsy"
    
    [root@test-c6 ~]# chmod 600 .my.cnf
    [root@test-c6 ~]# mysql
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 34
    Server version: 5.7.32 MySQL Community Server (GPL)
    ...
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    mysql>

# 2，配置root远程登录 #

mysql8.0.x默认的密码加密方式：[https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html\#sysvar\_default\_authentication\_plugin][https_dev.mysql.com_doc_refman_8.0_en_server-system-variables.html_sysvar_default_authentication_plugin]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V5ZW9mZWFnbGU_size_16_color_FFFFFF_t_70]

#1,允许root远程登陆: 8.0.13版本 Default Value (>= 8.0.4)0，
    # 使用caching_sha2_password验证方式，很多客户端不支持，
    # 需要改回默认的登录认证方式： mysql_native_password
    mysql>  use mysql; 
    mysql>  update user set host='%' where user='root';
    mysql>  alter user 'root'@'%' identified with mysql_native_password BY 'ABCxyz%123!'; 
    
    #2,刷新权限
    mysql> flush privileges;
    Query OK, 0 rows affected (0.01 sec)

[https_dev.mysql.com_doc_refman_8.0_en_linux-installation-yum-repo.html]: https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
[https_dev.mysql.com_doc_refman_8.0_en_resetting-permissions.html]: https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
[https_dev.mysql.com_doc_refman_5.7_en_password-security-user.html]: https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
[https_dev.mysql.com_doc_refman_8.0_en_server-system-variables.html_sysvar_default_authentication_plugin]: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V5ZW9mZWFnbGU_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200111214655561.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V5ZW9mZWFnbGU=,size_16,color_FFFFFF,t_70