How an account would be added to the user table : User Table « User Permission « SQL / MySQL






How an account would be added to the user table

      

SELECT host, user, select_priv, update_priv FROM user WHERE user='user1';

   
    
    
    
    
    
  








Related examples in the same category

1.Query user table
2.Deal with users who can log in from anywhere
3.Check the user_auths table
4.Check the just created user by querying the user table
5.Verify that the user table contains the proper host and user rows.
6.Query the user table
7.Check for user authentication for current user