Rename user : Rename User « User Permission « SQL / MySQL

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

Rename user

      

RENAME USER
   'CHRIS1'@'sql.r20.com' TO 'COMBO1'@'sql.r20.com',
   'CHRIS2'@'%' TO 'COMBO2'@'sql.r20.com'
;
SELECT   *
FROM     USERS
WHERE    USER_NAME LIKE '''COMBO%';

   
    
    
    
    
    
  

Related examples in the same category