MySQL October 24, 2010

MySQL – create user and grant all privileges

Create user with mysql command:

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

Add all privilleges to databases for user:

GRANT ALL ON *.* TO 'username'@'localhost';