最新文章專(zhuān)題視頻專(zhuān)題問(wèn)答1問(wèn)答10問(wèn)答100問(wèn)答1000問(wèn)答2000關(guān)鍵字專(zhuān)題1關(guān)鍵字專(zhuān)題50關(guān)鍵字專(zhuān)題500關(guān)鍵字專(zhuān)題1500TAG最新視頻文章推薦1 推薦3 推薦5 推薦7 推薦9 推薦11 推薦13 推薦15 推薦17 推薦19 推薦21 推薦23 推薦25 推薦27 推薦29 推薦31 推薦33 推薦35 推薦37視頻文章20視頻文章30視頻文章40視頻文章50視頻文章60 視頻文章70視頻文章80視頻文章90視頻文章100視頻文章120視頻文章140 視頻2關(guān)鍵字專(zhuān)題關(guān)鍵字專(zhuān)題tag2tag3文章專(zhuān)題文章專(zhuān)題2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章專(zhuān)題3
問(wèn)答文章1 問(wèn)答文章501 問(wèn)答文章1001 問(wèn)答文章1501 問(wèn)答文章2001 問(wèn)答文章2501 問(wèn)答文章3001 問(wèn)答文章3501 問(wèn)答文章4001 問(wèn)答文章4501 問(wèn)答文章5001 問(wèn)答文章5501 問(wèn)答文章6001 問(wèn)答文章6501 問(wèn)答文章7001 問(wèn)答文章7501 問(wèn)答文章8001 問(wèn)答文章8501 問(wèn)答文章9001 問(wèn)答文章9501
當(dāng)前位置: 首頁(yè) - 科技 - 知識(shí)百科 - 正文

詳解mysql5.7密碼忘記解決方法

來(lái)源:懂視網(wǎng) 責(zé)編:小采 時(shí)間:2020-11-09 21:15:04
文檔

詳解mysql5.7密碼忘記解決方法

詳解mysql5.7密碼忘記解決方法:ENV: [root@centos7 ~]# uname -r 3.10.0-514.el7.x86_64 [root@centos7 ~]# cat /etc/redhat-release CentOS Linux release 7.3.1611 (Core) [root@centos7 ~]# rpm -qa mysql [root@centos
推薦度:
導(dǎo)讀詳解mysql5.7密碼忘記解決方法:ENV: [root@centos7 ~]# uname -r 3.10.0-514.el7.x86_64 [root@centos7 ~]# cat /etc/redhat-release CentOS Linux release 7.3.1611 (Core) [root@centos7 ~]# rpm -qa mysql [root@centos

ENV:

[root@centos7 ~]# uname -r
3.10.0-514.el7.x86_64
[root@centos7 ~]# cat /etc/redhat-release 
CentOS Linux release 7.3.1611 (Core) 
[root@centos7 ~]# rpm -qa mysql
[root@centos7 ~]# rpm -qa |grep mysql
mysql-community-common-5.7.26-1.el7.x86_64
mysql-community-client-5.7.26-1.el7.x86_64
mysql57-community-release-el7-11.noarch
mysql-community-server-5.7.26-1.el7.x86_64
mysql-community-libs-5.7.26-1.el7.x86_64
mysql-community-libs-compat-5.7.26-1.el7.x86_64

登陸時(shí)出錯(cuò):

[root@centos7 ~]# mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

密碼忘記了(和剛安裝后不知道密碼一樣)

網(wǎng)上有人說(shuō)mysql的密碼是空密碼,其實(shí)在mysql5.7版本之后,密碼不再是空密碼了,

如果是剛安裝的,可以在mysql的日志文件找到

grep 'temporary password' /var/log/mysqld.log

補(bǔ)充:如果找到mysql提供的密碼,可以使用

mysqladmin -u root -p 'mysql提供的密碼' password ‘自己的新密碼' 

直接修改mysql的密碼,但這種方法存在安全隱患,畢竟密碼在命令行上顯示了,不建議但不反對(duì)。

如果是忘記,修改如下:

1.修改 /etc/my.cnf,加入 skip-grant-tables;

[root@centos7 ~]# vim /etc/my.cnf

空白位置加入,并保存退出;

[mysqld]
 
skip-name-resolve
skip-grant-tables
[root@centos7 ~]# systemctl restart mysqld

2.空密碼直接進(jìn)入mysql;

[root@centos7 ~]# mysql -u root -p
Enter password: (這里是空密碼,直接回車(chē))
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.26 MySQL Community Server (GPL)
 
Copyright (c) 2000, 2019, 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>

進(jìn)入mysql庫(kù);

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql>

這里的mysql并不是沒(méi)變,數(shù)據(jù)庫(kù)位置是變化的;

3.修改密碼:UPDATE user SET authentication_string=PASSWORD('newpassword') where USER='root';

mysql> UPDATE user SET authentication_string=PASSWORD('newpassword') where USER='root';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
 
mysql> 
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
 
mysql>

4改回/etc/my.cnf

注釋掉 #skip-grant-tables

[root@centos7 ~]# vim /etc/my.cnf
[mysqld]
 
skip-name-resolve
#skip-grant-tables
[root@centos7 ~]# systemctl restart mysqld

5.用新的密碼再進(jìn)入mysql;

[root@centos7 ~]# mysql -u root -p 
Enter password: (之前演示為newpassword)
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.26
 
Copyright (c) 2000, 2019, 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>

6.更改root密碼,更改root密碼: alter user 'root'@'localhost' identified by '密碼';

修改用戶(hù)密碼;

ALTER USER testuser IDENTIFIED BY '123456';

修改當(dāng)前登錄用戶(hù)

ALTER USER USER() IDENTIFIED BY '123456';
mysql> alter user user() identified by 'Linuxpassword!@#';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> alter user user() identified by 'LINUX123password!@#';
Query OK, 0 rows affected (0.00 sec)
 
mysql> 

可以看出,密碼的復(fù)雜度有了很大的要求;

7.修改完成后就可以繼續(xù)操作mysql了

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
 
mysql> exit
Bye

以上所述是小編給大家介紹的mysql5.7密碼忘記解決方法詳解整合,希望對(duì)大家有所幫助,如果大家有任何疑問(wèn)請(qǐng)給我留言,小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)腳本之家網(wǎng)站的支持!

您可能感興趣的文章:

  • 解決Linux下Mysql5.7忘記密碼問(wèn)題
  • mysql5.7及mysql 8.0版本修改root密碼的方法小結(jié)
  • MySQL5.7.20解壓版安裝和修改root密碼的教程
  • MySQL5.7.21安裝與密碼圖文配置教程
  • Centos7.3下mysql5.7.18安裝并修改初始密碼的方法
  • mysql5.7.18安裝并修改初始密碼的方法
  • MySQL5.7.18修改密碼的方法
  • MAC下Mysql5.7.10版本修改root密碼的方法
  • Mysql5.7忘記root密碼怎么辦(簡(jiǎn)單且有效方法)
  • Mysql5.7.14安裝配置方法操作圖文教程(密碼問(wèn)題解決辦法)
  • 聲明:本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí),若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系,我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

    文檔

    詳解mysql5.7密碼忘記解決方法

    詳解mysql5.7密碼忘記解決方法:ENV: [root@centos7 ~]# uname -r 3.10.0-514.el7.x86_64 [root@centos7 ~]# cat /etc/redhat-release CentOS Linux release 7.3.1611 (Core) [root@centos7 ~]# rpm -qa mysql [root@centos
    推薦度:
    標(biāo)簽: 密碼 方法 忘記
    • 熱門(mén)焦點(diǎn)

    最新推薦

    猜你喜歡

    熱門(mén)推薦

    專(zhuān)題
    Top
    fffffffffffff