crustibooga Posted August 29, 2008 Share Posted August 29, 2008 Database server was not found. Please verify the login, password, and database server name fields.System: PHP 5.2.6, MySQL 5.0.45 on Xserve Leopard Server OS 10.5.4Database server name : localhost (have used 127.0.0.1 / PARA.PAR.QTS01 & PARA.PAR.QTS01.private)Database name : prestashop (confirmed exists via terminal)All have been checked re checked, rebooted, re-entered etc. and still it's not working. Please help as I'm absolutely stumped?Cheers!! Link to comment Share on other sites More sharing options...
jtyana Posted August 29, 2008 Share Posted August 29, 2008 Does your database username have the correct permissions/priviledgesAre you sure your database username/login is correct. Did you use upper/lower case in your username/passwordThat's all I can think of Link to comment Share on other sites More sharing options...
crustibooga Posted August 29, 2008 Author Share Posted August 29, 2008 Hi, thanks for the quick reply. Have checked it all again and all is correct: permissions/privileges good - database username/login good - upper and lower case characters good.Stumped | Link to comment Share on other sites More sharing options...
AreMain Posted August 30, 2008 Share Posted August 30, 2008 Hi..i have the same problem..database server name not found, username and password not found too. actually..i dont understand what is actually the database server name? is it My SQL, phpMyAdmin, or it is anything else..please specific and provide some example..For information my website hosted by ixiy.com, a commercial hosting provider. Link to comment Share on other sites More sharing options...
crustibooga Posted September 1, 2008 Author Share Posted September 1, 2008 I'm no network expert, but is it possible for the data centre to block communications between port 80 and 3306? Link to comment Share on other sites More sharing options...
mudisel Posted September 2, 2008 Share Posted September 2, 2008 I had the same problem. i created user in my hosting for database i solved the problem.database server name is the ip number of your website.When you create database in hosting pannel there will be an ip number near the database name.That is the database server name. 1 Link to comment Share on other sites More sharing options...
crucialp Posted October 20, 2008 Share Posted October 20, 2008 A quick thing to note: I could find that the database wont connect if the database password contains special characters. So try with a different password, avoiding "+", "@" symbols. Link to comment Share on other sites More sharing options...
ioane Posted February 28, 2010 Share Posted February 28, 2010 A quick thing to note: I could find that the database wont connect if the database password contains special characters. So try with a different password, avoiding "+", "@" symbols. I can confirm that. I had a very secure, generated password that contained - & { / It didn't work till i changed the password to something simpler. It seems Prestashop doesn't like secure passwords. Link to comment Share on other sites More sharing options...
rocky Posted March 1, 2010 Share Posted March 1, 2010 Yep, that's true in Prestashop v1.3 alpha 1 and below. In Prestashop v1.3 alpha 2, you can now use more characters in the password (!@#$%^&*()). Link to comment Share on other sites More sharing options...
ioane Posted March 1, 2010 Share Posted March 1, 2010 Yep, that's true in Prestashop v1.3 alpha 1 and below. In Prestashop v1.3 alpha 2, you can now use more characters in the password (!@#$%^&*()). good to know. Link to comment Share on other sites More sharing options...
kanoute696 Posted April 3, 2010 Share Posted April 3, 2010 hi there , im new to this - same issue - I have windows 2008 and Mysql - using test as a username and password but still giving Database server was not found. Please verify the login, password, and database server name fields.would really appreciate some help on this .... Thank you Link to comment Share on other sites More sharing options...
nigelt Posted April 4, 2010 Share Posted April 4, 2010 hi there , im new to this - same issue - I have windows 2008 and Mysql - using test as a username and password but still giving Database server was not found. Please verify the login, password, and database server name fields.would really appreciate some help on this .... Thank you I had the same problem.Trying to install on my laptop using uniserver.It kept complaining about the same thing.Changed the database server entry from localhost to 127.0.0.1 Sorted ! Link to comment Share on other sites More sharing options...
ericamattos Posted April 25, 2010 Share Posted April 25, 2010 I have the same problem.. "Database server was not found. Please verify the login, password, and database server name fields."My server is godaddy... anyone knows how to solve this?! Link to comment Share on other sites More sharing options...
blooeyesuk Posted April 30, 2010 Share Posted April 30, 2010 Like many others I have been pulling my hair out with this same problem but even more frustrating is the fact that I got it working the first time i installed it a few months ago!Mine now recognises that the server name is correct having deleted everything and entered 127.0.0.1 but now it says "Database Server is available but database is not found."I created the database through the cpPanel on my web server via host UK2.NET and it definately does exist - any ideas????I can feel my life ebbing away!Quick........................! Link to comment Share on other sites More sharing options...
ioane Posted April 30, 2010 Share Posted April 30, 2010 you also have to create a user for the database, and associate the user to the database Link to comment Share on other sites More sharing options...
blooeyesuk Posted April 30, 2010 Share Posted April 30, 2010 nice one! thank you - all working. Link to comment Share on other sites More sharing options...
MahmutGulerce Posted July 10, 2011 Share Posted July 10, 2011 Hi;It can be fixed as the same user name and database name.Eg:user name = prestashop_15database = prestashop_15I feel that ajax method has bugs Link to comment Share on other sites More sharing options...
blooeyesuk Posted July 10, 2011 Share Posted July 10, 2011 Thanks for trying but that doesn't work either.I have tries every combination, deletede and started again, copied settings from my other Prestashopshop which does work but nothing?I'm almost ready to dump Prestashop because I waste so much time every time I install a new shop.ThanksTimwww.blooeyes.com (works)www.allglammedup.com (won't work) Link to comment Share on other sites More sharing options...
dicaripolisi Posted September 28, 2012 Share Posted September 28, 2012 (edited) Thanks for trying but that doesn't work either. I have tries every combination, deletede and started again, copied settings from my other Prestashopshop which does work but nothing? I'm almost ready to dump Prestashop because I waste so much time every time I install a new shop. Thanks Tim www.blooeyes.com (works) www.allglammedup.com (won't work) point to my.ini ( mysql) is it localhost or 127.0.0.1 or (your.ip.address) ? ensure to fill the same with that config on your database config. Edited September 28, 2012 by dicaripolisi (see edit history) Link to comment Share on other sites More sharing options...
phobet Posted November 25, 2013 Share Posted November 25, 2013 One issue that I have discovered is that if the user password is too long, you will get this. I shortened this to 10 characters, and it worked. Link to comment Share on other sites More sharing options...
Con6tY5efs Posted November 25, 2013 Share Posted November 25, 2013 (edited) you use upper/lower case in your username/password Edited November 25, 2013 by Con6tY5efs (see edit history) Link to comment Share on other sites More sharing options...
Agilemedia Posted January 16, 2018 Share Posted January 16, 2018 Database User Password should have a strength of at least 50% and we found that 10 characters work. We had the same problem, used the host ip, 127.0.0.1, tried renaming the username the same as dbname, nothing. It's just the password, that should be 10 characters long. Oh, and it does include special characters. Too bad there is no information about setting the password length/strength in the installation guide. Bottom line: 10 characters password with a strength ofer 50%, your database ip, database name, username, user password, and ps_ in the last field. Link to comment Share on other sites More sharing options...
Djayja Posted January 5, 2022 Share Posted January 5, 2022 My phpMyAdmin database was running on port 8889 but Prestashop is using port 3306 by default. So, adding the port name solved the issue for me. Link to comment Share on other sites More sharing options...
JBW Posted January 7, 2022 Share Posted January 7, 2022 On 1/16/2018 at 1:29 PM, Agilemedia said: 10 characters password with a strength ofer 50%, There is no such requirement, must have been a different issue with your password 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