Adding MySQL Users

Here’s the syntax to add a user to MySQL:

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

Posted on February 23, 2005 by admin in MySQL