Shulou(Shulou.com)06/01 Report--

This article is about how to view mysql usernames and passwords. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

The way to check the username and password of mysql is to log in to the mysql server first, and then execute the [select * from mysql.user;] statement to output the username and password.

Specific methods:

First, log in to mysql. If the login is successful, the following information will be displayed.

Then execute the sql statement

Select * from mysql.user

You can see that the password is encrypted.

Thank you for reading! This is the end of the way to view mysql username and password. I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.