Newbie: Listing users 2

[ribsa3]

Hi

Quite simply, I would like to list the users and their permissions on my MySQL server. Child's play, but I hope you'll help me anyway!

Kindly,

Bjoern Sandvik

 

[TonyGroves]

You can do normal SELECT queries on the user, db, tables_priv, and columns_priv tables, which can show all users and their privileges.

You can also do [tt]SHOW GRANTS FOR username@hostname[/tt]
which will recreate a GRANT statement for the named user.

-----
ALTER world DROP injustice, ADD peace;

 

[OGHS]

Hi. I just wanted to add something to the last answer, those queries must be done on the mysql database so you should do something like:

mysql> use mysql;
mysql> select user, host from user;