FreeKB - mySQL / MariaDB display users using the SELECT USERS statement
mySQL / MariaDB - display users using the SELECT USERS statement

This assume you are able to log into your MariaDB or mySQL server or you have configured passwordless authentication and will be using the -e command line option. 

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 c9fdb 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   |