Perl ABC

View user list in MySQL/MySQL memo

Note that I always forget how to display the user list in MySQL .

SELECT User, Host FROM mysql.user;

In MySQL, the host name and user name are one set, so multiple user names are displayed.

To MySQL memo