Mega Code Archive

 

Categories / MySQL / User Permission

 

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;