Tell me more ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.
up vote 1 down vote favorite

At stage 3 of the Prestashop Installation, I enter the DB details which I know to be correct, and I receive the error:

Database server was not found. Please verify the login, password, and database server name fields.

The server is localhost, and I have verified the database name and username. Why can Prestashop not find the server?

This occurs when choosing InnoDB and MyIsam.

If I change the server from localhost to the public hostname I receive the same error.

share|improve this question
1  
1) Double check that you can actually login into DB using those details (you may have correct login/database in place, but, probably, username was set up in such way that it not allowed to connect from that address); 2) Please check if you can connect to that DB from within PHP (create some simple test PHP script) -- maybe you do not have required extensions enabled; 3) Firewall? (don't think so .. but); 4) Server address: try 127.0.0.1 instead of localhost.. or you may need to specify some another name (linux socket?) -- consult your hoster for exact details – LazyOne Jul 10 '11 at 10:40

3 Answers

up vote 1 down vote accepted

I recreated a 2nd user account, which tested okay.

share|improve this answer
up vote 0 down vote

Go to the members' area, enter the control panel and click on the 'MySQL' icon. Your MySQL hostname / username / database name etc will be listed there.

Also make sure you use the correct hostname, not localhost.

share|improve this answer
The OP has already stated that the correct hostname is localhost and that the problem was related to the user and not the database connection. – w3d Nov 7 '12 at 8:26
up vote 0 down vote

Be careful about the collation settings of the database you created. Collation must be utf8_general_ci for database prestashop. Otherwise you receive connection error.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.