Check the just created user by querying the user table : User Table « User Permission « SQL / MySQL






  1. SQL / MySQL
  2. User Permission
  3. User Table

Check the just created user by querying the user table

      

CREATE USER
   'CHRIS1'@'sql.r20.com' IDENTIFIED BY 'CHRISSEC1',
   'CHRIS2'@'%' IDENTIFIED BY 'CHRISSEC2',
   'CHRIS3'@'%.r20.com' IDENTIFIED BY 'CHRISSEC3'
;


SELECT   *
FROM     USERS
WHERE    USER_NAME LIKE '''CHRIS%'
ORDER    BY 1;








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