cancel
Showing results for 
Search instead for 
Did you mean: 

Trouble creating user for installation

SOLVED

Trouble creating user for installation

I'm trying to install the latest version of the community edition on a hosted web site.  I've been using the instructions here:

http://devdocs.magento.com/guides/m1x/install/installing_install.html#install-troubleshoot

 

I created the database magento but I'm having trouble with the next instruction:

 GRANT ALL ON magento.* TO magento@localhost IDENTIFIED BY 'magento';

 

GRANT ALL ON magento.* TO magento@localhost IDENTIFIED BY 'magento'; 

My host won't let me run this SQL command and I can't create the user through the site's SQL interface either.  If I create a user "magento" with password "magento"  I get a security error (pass can't be same as user).  And I can't create a user named "magento@localhost" because the name is too long.

 

Any suggestions?  Am I doing something wrong?

1 REPLY

Re: Trouble creating user for installation

The MySQL user that is stated in the installation guide is "magento", not "magento@localhost". Anyway you are free to set the MySQL user as any name as long as you remember it during the installation process. 

 

You should also set a MySQL password which is different from your username. 

James Lee | Moderator • Magento Master
See My Recommended Magento Hosting & Security Tips