新闻动态
新闻动态
NEWS INFORMATION

mysql8.0.19忘记密码处理方法详解

发布日期:2022-07-15 19:05 | 文章来源:站长之家

1在配置文件中添加skip-grant-tables后重启mysql,然后直接登录

[root@tyjs09 ~]# cat /etc/my.cnf
[mysqld]
user=mysql
basedir=/application/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
server_id=6
port=3306
gtid-mode=on
enforce-gtid-consistency=true
log_error=/data/mysql/data/mysql.log
log_bin=/data/binlog/mysql-bin
secure-file-priv=/tmp
innodb_flush_method=O_DIRECT
lower_case_table_names=1
skip-grant-tables

2更新密码

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> alter user "root"@"localhost" identified by "123456";
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
mysql> use mysql;select user,host from user;root | % |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;

3在配置文件中去掉免登录然后重启mysql:

[root@tyjs09 ~]# vim /etc/my.cnf
[mysqld]
user=mysql
basedir=/application/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
server_id=6
port=3306
gtid-mode=on
enforce-gtid-consistency=true
log_error=/data/mysql/data/mysql.log
log_bin=/data/binlog/mysql-bin
secure-file-priv=/tmp
innodb_flush_method=O_DIRECT
lower_case_table_names=1
skip-grant-tables #去掉
[root@tyjs09 ~]# service mysql restart
Shutting down MySQL.. SUCCESS!
Starting MySQL. SUCCESS!
[root@tyjs09 ~]# mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.19 MySQL Community Server - GPL
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

到此这篇关于mysql8.0.19忘记密码处理方法详解的文章就介绍到这了,更多相关mysq忘记密码处理内容请搜索本站以前的文章或继续浏览下面的相关文章希望大家以后多多支持本站!

美国服务器租用

版权声明:本站文章来源标注为YINGSOO的内容版权均为本站所有,欢迎引用、转载,请保持原文完整并注明来源及原文链接。禁止复制或仿造本网站,禁止在非www.yingsoo.com所属的服务器上建立镜像,否则将依法追究法律责任。本站部分内容来源于网友推荐、互联网收集整理而来,仅供学习参考,不代表本站立场,如有内容涉嫌侵权,请联系alex-e#qq.com处理。

实时开通

自选配置、实时开通

免备案

全球线路精选!

全天候客户服务

7x24全年不间断在线

专属顾问服务

1对1客户咨询顾问

在线
客服

在线客服:7*24小时在线

客服
热线

400-630-3752
7*24小时客服服务热线

关注
微信

关注官方微信
顶部