如何查看MySQL连接的root密码

数据库  /  管理员 发布于 6年前   172

本文给大家分享的是查看MySQL连接的root密码的方法，下面话不多说来来看正文：

1.首先我们进到MySQL的bin目录下

➜ cd /usr/local/mysql/bin

2.切换成root身份

➜ bin sudo su

3.跨过权限的验证

sh-3.2# ./mysqld_safe --skip-grant-tables &[1] 9451sh-3.2# 2017-01-03T15:40:10.6NZ mysqld_safe Logging to '/usr/local/mysql/data/yzydeMacBook-Pro.local.err'.2017-01-03T15:40:10.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

4.以root身份登录MySQL

./mysql -urootWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.7.12 MySQL Community Server (GPL)Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

5.选择mysql数据库

mysql> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changed

6.显示mysql数据库下的表

mysql> show tables;+---------------------------+| Tables_in_mysql   |+---------------------------+| columns_priv    || db      || engine_cost    || event      || func      || general_log    || gtid_executed    || help_category    || help_keyword    || help_relation    || help_topic    || innodb_index_stats  || innodb_table_stats  || ndb_binlog_index   || plugin     || proc      || procs_priv    || proxies_priv    || server_cost    || servers     || slave_master_info   || slave_relay_log_info  || slave_worker_info   || slow_log     || tables_priv    || time_zone     || time_zone_leap_second  || time_zone_name   || time_zone_transition  || time_zone_transition_type || user      |+---------------------------+31 rows in set (0.00 sec)

7.很明显我们需要的密码是存在user这个表下的，所以我们直接看user的表结构是怎么样的

mysql> show columns from user;+------------------------+-----------------------------------+------+-----+-----------------------+-------+| Field     | Type        | Null | Key | Default    | Extra |+------------------------+-----------------------------------+------+-----+-----------------------+-------+| Host     | char(60)       | NO | PRI |      |  || User     | char(32)       | NO | PRI |      |  || Select_priv   | enum('N','Y')      | NO |  | N      |  || Insert_priv   | enum('N','Y')      | NO |  | N      |  || Update_priv   | enum('N','Y')      | NO |  | N      |  || Delete_priv   | enum('N','Y')      | NO |  | N      |  || Create_priv   | enum('N','Y')      | NO |  | N      |  || Drop_priv    | enum('N','Y')      | NO |  | N      |  || Reload_priv   | enum('N','Y')      | NO |  | N      |  || Shutdown_priv   | enum('N','Y')      | NO |  | N      |  || Process_priv   | enum('N','Y')      | NO |  | N      |  || File_priv    | enum('N','Y')      | NO |  | N      |  || Grant_priv    | enum('N','Y')      | NO |  | N      |  || References_priv  | enum('N','Y')      | NO |  | N      |  || Index_priv    | enum('N','Y')      | NO |  | N      |  || Alter_priv    | enum('N','Y')      | NO |  | N      |  || Show_db_priv   | enum('N','Y')      | NO |  | N      |  || Super_priv    | enum('N','Y')      | NO |  | N      |  || Create_tmp_table_priv | enum('N','Y')      | NO |  | N      |  || Lock_tables_priv  | enum('N','Y')      | NO |  | N      |  || Execute_priv   | enum('N','Y')      | NO |  | N      |  || Repl_slave_priv  | enum('N','Y')      | NO |  | N      |  || Repl_client_priv  | enum('N','Y')      | NO |  | N      |  || Create_view_priv  | enum('N','Y')      | NO |  | N      |  || Show_view_priv   | enum('N','Y')      | NO |  | N      |  || Create_routine_priv | enum('N','Y')      | NO |  | N      |  || Alter_routine_priv  | enum('N','Y')      | NO |  | N      |  || Create_user_priv  | enum('N','Y')      | NO |  | N      |  || Event_priv    | enum('N','Y')      | NO |  | N      |  || Trigger_priv   | enum('N','Y')      | NO |  | N      |  || Create_tablespace_priv | enum('N','Y')      | NO |  | N      |  || ssl_type    | enum('','ANY','X509','SPECIFIED') | NO |  |      |  || ssl_cipher    | blob        | NO |  | NULL     |  || x509_issuer   | blob        | NO |  | NULL     |  || x509_subject   | blob        | NO |  | NULL     |  || max_questions   | int(11) unsigned     | NO |  | 0      |  || max_updates   | int(11) unsigned     | NO |  | 0      |  || max_connections  | int(11) unsigned     | NO |  | 0      |  || max_user_connections | int(11) unsigned     | NO |  | 0      |  || plugin     | char(64)       | NO |  | mysql_native_password |  || authentication_string | text        | YES |  | NULL     |  || password_expired  | enum('N','Y')      | NO |  | N      |  || password_last_changed | timestamp       | YES |  | NULL     |  || password_lifetime  | smallint(5) unsigned    | YES |  | NULL     |  || account_locked   | enum('N','Y')      | NO |  | N      |  |+------------------------+-----------------------------------+------+-----+-----------------------+-------+45 rows in set (0.02 sec)

8.表的内容比较多，但是我们很容易就发现，密码其实是存在authentication_string字段下的，那我们就可以直接读User内容为root的密码了

mysql> select authentication_string from user where User='root';+-------------------------------------------+| authentication_string      |+-------------------------------------------+| *781D25322166DB7FF99BA4A1FA5ED30439A60DDE |+-------------------------------------------+1 row in set (0.01 sec)

OK，那我们拿着这个密码到Navicat试试看

 

总结

好了，以上就是这篇文章的全部内容了，希望本文的内容对大家的学习或者工作能带来一定的帮助，如果有疑问大家可以留言交流。