View Single Post
  #32  
Old 5th December 2012, 13:14
grungy grungy is offline
Senior Member
 
Join Date: Dec 2008
Posts: 147
Thanks: 12
Thanked 9 Times in 6 Posts
Default

Code:
mysql> SELECT user,host,password FROM mysql.user WHERE user = 'root' ORDER BY host ASC;
+------+-------------------------------+-------------------------------------------+
| user | host                          | password                                  |
+------+-------------------------------+-------------------------------------------+
| root | %                                    | *E6-------------------------------------- |
| root | 127.0.0.1                         |  blank password                                 |
| root | remote.host1                    | *E6-------------------------------------- |
| root | remote.host2                    | *E6-------------------------------------- |
| root | localhost                           | *E6-------------------------------------- |
| root | localhost.localdomain         |  blank password                                |
+------+-------------------------------+-------------------------------------------+
Reply With Quote