mysql> SELECT * FROM mysql.user; +-----------+----------+------------------+-------------+-------------+-------------+----- --------+-------------+-----------+-------------+---------------+--------------+---------- -+------------+-----------------+------------+------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-----------+----------+------------------+-------------+-------------+-------------+----- --------+-------------+-----------+-------------+---------------+--------------+---------- -+------------+-----------------+------------+------------+ | localhost | root | 108098121fd79055 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | server | root | 108098121fd79055 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | shop | 6dcf7d3c05385533 | Y | Y | Y | Y | Y | Y | N | N | N | N | N | N | N | N | | % | com75778 | 734274b10cfd3bbb | Y | Y | Y | Y | Y | Y | N | N | N | N | N | N | N | N | +-----------+----------+------------------+-------------+-------------+-------------+----- --------+-------------+-----------+-------------+---------------+--------------+---------- -+------------+-----------------+------------+------------+ 4 rows in set (0.01 sec) mysql>