Deal with users who can log in from anywhere : User Table « User Permission « SQL / MySQL






Deal with users who can log in from anywhere

      
mysql>
mysql>
mysql> SELECT user, host, password FROM mysql.user WHERE host = '%';
Empty set (0.00 sec)

mysql>

   
    
    
    
    
    
  








Related examples in the same category

1.Query user table
2.Check the user_auths table
3.Check the just created user by querying the user table
4.Verify that the user table contains the proper host and user rows.
5.How an account would be added to the user table
6.Query the user table
7.Check for user authentication for current user