Thomas Networks

There are times when you are stuck adding MySQL users via command line if this is one you are in luck.

On the machine MySQL is installed on run the following command. NOTE: there is no space between -p and ‘password’ and that ‘password’ is your password for root or the user you specify after -u.

mysql -h localhost -u root -ppassword

At the mysql> prompt enter the following commands. NOTE: In production you should replace ‘%’ with the ip or hostname you will be conecting from.

CREATE USER `magento`@'%' IDENTIFIED BY 'password';

Output should be:

Query OK, 0 rows affected (0.00 sec)

For a more thorough explanation of the CREATE USER syntax see: http://dev.mysql.com/doc/refman/5.0/en/create-user.html

Now to grant access…
Grant Access to all.. be careful if you execute this command you essentially adding a root user.

GRANT ALL ON *.* TO 'magento'@'%';

If you had a database named ‘magento’ you should change the command to look like..

GRANT ALL ON 'magento'.* TO 'magento'@'%';

To create a read only user…

GRANT SELECT ON 'magento'.* TO 'magento'@'%';

For a more thorough explanation of the GRANT syntax see: http://dev.mysql.com/doc/refman/5.0/en/grant.html

Any questions?