Re: How to list user and password
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
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.