Friday, July 30, 2010

Create MySQL accounts from command line

mysql --user="root" --password="your_root_password"

CREATE USER 'new_username'@'localhost' IDENTIFIED BY 'password_for_new_username';

GRANT ALL ON *.* TO 'new_username'@'localhost'; (change for your security/access situation)

exit