FreeKB - SELECT USER statement
mySQL / MariaDB - SELECT USER statement

This assume you are able to connect to MariaDB

Use the following command to view the current users. In this example, there are 3 user accounts for root.

MariaDB [(none)]> select user,host,password from mysql.user;
+------------------+--------------------------------+
| user | host      | password                       |
+------------------+--------------------------------+
| root | 127.0.0.1 | *5H4H5GF9S8733H3F93F9F3JF93837 |
| root | ::1       | *5H4H5GF9S8733H3F93F9F3JF93837 |
| root | localhost | *5H4H5GF9S8733H3F93F9F3JF93837 |
+------------------+--------------------------------+
3 rows in set (0.00 sec)

 



Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter fb6a1 in the box below so that we can be sure you are a human.




Comments

Web design by yours truely - me, myself, and I   |   jeremy.canfield@freekb.net   |