MySQL : Adding Users

Created 12 October 2004 00:00

Log in to mysql:

 mysql --user=root <database>

Grant all privileges on the local machine:

  GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

Grant all privileges from other machines:

  GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;