How to create, rename, and drop users

      CREATE USER joel@localhost IDENTIFIED BY 'sesame'; 
      

      CREATE USER dba IDENTIFIED BY 'sesame'; --creates 'dba@%'
      

      RENAME USER joel@localhost TO joelmurach@localhost;
      

      GRANT USAGE ON *.* TO joelmurach@localhost IDENTIFIED BY 'newpassword';
      

      DROP USER joelmurach@localhost;
      

      DROP USER dba; --drops 'dba@%'
      

Description

• You use the CREATE USER statement to create a user that has no privileges.
• If you want to specify the host for a user, you can code the username, followed by the @ character, followed by the hostname.
• If you specify a user without specifying a hostname, MySQL uses a percentage sign (%) as a wildcard character to indicate that the user can be from any host.
• You can use the RENAME USER statement to change the name of a user.
• You can use the GRANT statement to change a user’s password.
• You can use the DROP USER statement to drop a user.