mysql show and add users code example Example: mysql show users select * from mysql.user; #or for less data select user, host from mysql.user;