Posts

Showing posts from November, 2015

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                                             ...