SRD75 Posted July 10, 2011 Share Posted July 10, 2011 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. Link to comment Share on other sites More sharing options...
MahmutGulerce Posted July 10, 2011 Share Posted July 10, 2011 HiDid you try to use same names with username and dbname.Eg: user name = prestashop_15database = prestashop_15 Link to comment Share on other sites More sharing options...
SRD75 Posted July 10, 2011 Author Share Posted July 10, 2011 No, because the username and database name are not the same; they are different. Link to comment Share on other sites More sharing options...
MahmutGulerce Posted July 10, 2011 Share Posted July 10, 2011 No, because the username and database name are not the same; they are different. Well can you try now ? Link to comment Share on other sites More sharing options...
SRD75 Posted July 10, 2011 Author Share Posted July 10, 2011 Nothing has changed. Why will it work now when it didn't work before? Link to comment Share on other sites More sharing options...
MahmutGulerce Posted July 10, 2011 Share Posted July 10, 2011 Nothing has changed. Why will it work now when it didn't work before? I ask you for try. But i think it was misunderstood. It worked for many of prestashop which have same problem, same issues. I tried same username and same dbname for one of them and it worked. Link to comment Share on other sites More sharing options...
SRD75 Posted July 10, 2011 Author Share Posted July 10, 2011 Okay, thanks for your try.I created the database and user account myself, so I know what the connection parameters should be, and I have installed many other web applications which use the same sort of credentials.They all connect okay to localhost. Prestashop itself recommend using localhost.The database is MySQL, PHP5 and the GD Library are installed. Link to comment Share on other sites More sharing options...
SRD75 Posted July 10, 2011 Author Share Posted July 10, 2011 You were also nearly correct. The hosting environment creates:a database called hostingusername_dbname, and a MySQL username called hostingusername_sqluserwhere you can make anything up after hostingusername_ Link to comment Share on other sites More sharing options...
MahmutGulerce Posted July 10, 2011 Share Posted July 10, 2011 You were also nearly correct. The hosting environment creates:a database called hostingusername_dbname, and a MySQL username called hostingusername_sqluserwhere you can make anything up after hostingusername_ yes many of hosting providers adds hostingusername_ prefix to new user / db names. (Im a hostmaster)Simply to creating a username "hostingusername_abcd" and a databasename "hostingusername_abcd" may work. It ıt must be fixed. Good luck Link to comment Share on other sites More sharing options...
SRD75 Posted July 10, 2011 Author Share Posted July 10, 2011 As I've already said, I have already used the correct format with other web applications, and I have confirmed I am using the correct database, username and password with Prestashop. There is nothing wrong with these values.Prestashop is the only application I have encountered which can't connect to localhost. Link to comment Share on other sites More sharing options...
SRD75 Posted July 10, 2011 Author Share Posted July 10, 2011 Also, Prestashop is not complaining about a username/password error, it is saying explicitly that it can't connect to localhost. Link to comment Share on other sites More sharing options...
MahmutGulerce Posted July 10, 2011 Share Posted July 10, 2011 SRD75I have never typed your db name or db user is incorrect. I only share my experience. And the "same named dbuser and dbname" advice was only for prestashop.good luck Link to comment Share on other sites More sharing options...
SRD75 Posted July 11, 2011 Author Share Posted July 11, 2011 I created a new username and associated it to the database.This fixed the problem.If the cause was an incorrect username/password, Prestashop should say so, not say "cannot connect to database server". Link to comment Share on other sites More sharing options...
MahmutGulerce Posted July 11, 2011 Share Posted July 11, 2011 I created a new username and associated it to the database.This fixed the problem.If the cause was an incorrect username/password, Prestashop should say so, not say "cannot connect to database server". Yes its a BUG and may related with ajax methods. Im glad it fixed. Regards Link to comment Share on other sites More sharing options...
mecollectibles Posted January 22, 2013 Share Posted January 22, 2013 I followed all steps but it did not work for me. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now