Create a new MySQL-user with all privileges
GRANT ALL PRIVILEGES ON thedatabase.* TO 'theusername'@'localhost' IDENTIFIED BY 'thepassword' WITH GRANT OPTION;
UPDATE 20080916: Skip the last line if the user exists.
personal knowledgebase
GRANT ALL PRIVILEGES ON thedatabase.* TO 'theusername'@'localhost' IDENTIFIED BY 'thepassword' WITH GRANT OPTION;
UPDATE 20080916: Skip the last line if the user exists.