Get list of MySQL user accounts

Get list of MySQL user accounts : If you are looking to get the list of the user accounts in mysql you can get this simply using the query from mysql.user table. Here in this example we are going to explain how you can get all the users of the mysql using the simple query.

Get list of MySQL user accounts

Here is simple query which will give you the list of the MySql User Accounts –

SELECT User FROM mysql.user;

The above example will give you the mysql users. It will produce output something like this –

MySql get Username, Password And Hostname

You can get the username, hostname and password from mysql simply using the query below –

SELECT User, Password, Host FROM mysql.user;

If you the above query it will give you the username, password and hostname. The output will be something like this –

Add Comment

📖 Read More

• 1. Can't connect to local MySQL server through socket '/var/mysql/mysql.sock'
• 2. MySQL Grant all privileges on database