FreeKB - SELECT USER in mySQL MariaDB
SELECT USER in mySQL MariaDB

Home > Search


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 d23c6 in the box below so that we can be sure you are a human.




Comments