MySQL Forums
Forum List  »  Newbie

Re: How to list user and password
Posted by: Stephen Liu
Date: May 19, 2015 06:50PM

Peter Brawley Wrote:
-------------------------------------------------------
> select host, user, password from mysql.user;
>
> Passwords are stored in encrypted form.
>
> Users are db-specific if and only if they have
> entries in the mysql.db table.

Hi,

Thanks for your advice.

mysql> select host, user, password from mysql.user;

+---------------------+------------------+-------------------------------------------+
| host | user | password |
+---------------------+------------------+-------------------------------------------+
| localhost | root |
| ub1404dkssd00lamp00 | root |
| 127.0.0.1 | root |
| ::1 | root |
| localhost | debian-sys-maint |
| localhost | phpmyadmin |
| % | wordpressuser |
| localhost | wordpressuser |
| % | dbuser |
| localhost | dbuser |
| localhost | wordpress |
| hymn.satimis.com | wordpress |
+---------------------+------------------+-------------------------------------------+

I expect to find the user of the databases, bible and hymn. I forgot their entries.

Is there any way to get the readable password from its encripted form?

Regards
satimis

Options: ReplyQuote


Subject
Written By
Posted
Re: How to list user and password
May 19, 2015 06:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.