#show all users and hosts SELECT User, Host FROM mysql.user; # show all users with passwords SELECT User, Host, Password, password_expired FROM mysql.user;