Mega Code Archive

 

Categories / MySQL / User Permission

 

Query user table

mysql> mysql> SELECT user, host, password FROM mysql.user; +------+-----------+----------+ | user | host      | password | +------+-----------+----------+ | root | localhost |          | | root | 127.0.0.1 |          | |      | localhost |          | +------+-----------+----------+ 3 rows in set (0.00 sec) mysql>