Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    63

    Unanswered: How to list user and password

    Hi all,

    mysql> show databases;
    +--------------------+
    | Database |
    +--------------------+
    | information_schema |
    | bible |
    | dbwordpress |
    | hymn |
    | mysql |
    | performance_schema |
    | phpmyadmin |
    +--------------------+

    How to list the user and password of the databases, bible and hymn? There is only one user on each of these databases.

    Thanks

    Regards
    satimis

  2. #2
    Join Date
    Jun 2011
    Posts
    31
    Provided Answers: 1
    You can use this query:
    mysql> select * from mysql.user;
    It will provide the user information, user permission etc.

    mysql> select host, user, password from mysql.user;
    This query provide you the detailed background information about the user.

  3. #3
    Join Date
    Jun 2006
    Posts
    63
    Hi,

    Thanks for your advice.

    Quote Originally Posted by addisionphilip View Post
    You can use this query:
    mysql> select * from mysql.user;
    It will provide the user information, user permission etc.
    It works here but it is not easy reading the output.

    mysql> select host, user, password from mysql.user;
    This query provide you the detailed background information about the user.
    mysql> select host, user, password from mysql.user;
    Code:
    +-----------+------------------+-------------------------------------------+
    | host      | user             | password                                  |
    +-----------+------------------+-------------------------------------------+
    | localhost | root             | *66EC159BF750C65B8E3CCE6BA835EC951A98C484 |
    | wp00pc1a  | root             | *66EC159BF750C65B8E3CCE6BA835EC951A98C484 |
    | 127.0.0.1 | root             | *66EC159BF750C65B8E3CCE6BA835EC951A98C484 |
    | ::1       | root             | *66EC159BF750C65B8E3CCE6BA835EC951A98C484 |
    | localhost | debian-sys-maint | *5F5917A5F91D76EC671F1623B146B8B8312C70B7 |
    .....
    ....
    Yes. It works here as well.

    Would it be possible to convert the encrypted password to readable password?

    Regards
    satimis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •