Show All Users in MySQL

SELECT User, Host FROM mysql.user;
/**
+------------------+-----------+
| User | Host |
+------------------+-----------+
| healthchecker | localhost |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
5 rows in set (0.01 sec)**/


Comments

Popular posts from this blog

Check MySQL query history from command line