mysql中怎么查看连接的密码是什么_如何查看MySQL连接的root密码

本文给大家分享的是查看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] 9451

sh-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 -uroot

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server 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 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.

5.选择mysql数据库

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

6.显示mysql数据库下的表

mysql> show tables;

+---------------------------+

| Tables_in_mys