Add manual user mysql

Added on May 29th, 2012 and marked as config database mysql

Step 1.

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

Step 2.

GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;

Step 3.

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `database_nl`.* TO 'username'@'localhost';

Flush the privileges of the newly created user:

FLUSH PRIVILEGES;