Add New User Accounts To MySQL

• Adding new user accounts to MySQL can be done in two ways:
  • Using statements intended for creating accounts, such as CREATE USER or GRANT
    • This is the preferred method because it is more concise and less error-prone.
  • Manipulating the MySQL grant tables directly with statements such as INSERT, UPDATE, or DELETE

• The CREATE USER syntax is:

  CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']]

  • The account can be given a password with the optional IDENTIFIED BY clause.

• Here are five examples on how to use GRANT to add new users.

  mysql> GRANT ALL PRIVILEGES ON *.* TO 'doe'@'localhost'
    -> IDENTIFIED BY 'password' WITH GRANT OPTION;
  

  mysql> GRANT ALL PRIVILEGES ON *.* TO 'doe'@'%'
    -> IDENTIFIED BY 'password' WITH GRANT OPTION;
  

  mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
  

  mysql> GRANT USAGE ON *.* TO 'doe'@'localhost';

  mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON database.*
    -> TO 'user'@'server.domain' IDENTIFIED BY 'password';

How do I remove user accounts from MySQL?

---

---

© 2007 John Michael Pierobon

Notes