mysql commands on users
mysql> select user,host from mysql.user; +---------+-----------------+ | user | host | +---------+-----------------+ | root | 127.0.0.1 | | root | linuxhost.local | | newuser | localhost | | root | localhost | +---------+-----------------+ 4 rows in set (0.14 sec) mysql> show grants for 'root'@'localhost'; +----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*84BB5DF4823DA319BBF86C99624479A198E6EEE9' WITH GRANT OPTION | +---------------------------------------------