This one is simple but I get tickets for it all the time.

select User,Host,Password from mysql.user;

You can also do a select all and format it better

select * from mysql.user\G

Tags:

Categories:

Updated: