Database Server is not found. Please verify the login, password and server fields (DbPDO)

[LUDMILA]

Hey guys, I am a first time user with little knowledge on this.

I am installing prestashop 1.7  on my localhost using wampserver.

When installing prestashop, on the page "Configure your database by filling out the following fields", I was asked the "database server name", database name, login, password, and when I tested, It gave me the message "Database Server is not found. Please verify the login, password and server fields (DbPDO)".

I had previously created a database on wampserver called prestashop 1.7.2.4, so it supposed to recognize.

I read something about SSL but i did not understand.

I have a host "hostinger.com" and I actually got the SSL there, but I choose to build the page in my computer first, and in the near future upload it.

Interesting is that when I tried to go to wamp and access prestashop file from there in other to begin instalation, it did not open. I was only able to start instalation because out of the blue i decide to type my webname cafedelospueblos.com and the instalation started. So i followed the steps.

What could be the problem?

Thanks for the help.

 

[Rhobur]

It is surely not related to SSL.

You probably have a typo in your info, database server name is localhost and the rest are infos that you previously set; make sure you type everything exactly, with same letter cases and punctuation.

[Peter Pastoor]

I have this problem with 1.7.4.2. I'm completely certain all information is complete. What can be the problem?

[ksaan]

Can you check whether you are able to connect to this database using a software such as MySQL workbench ?

This software will allow you to read and manage your database content provided it has the right informations which are the same required by prestashop:  database server name, database name, login, password. So if it works with MySQL workbench and not with Prestashop it is a bug. If it does not work for both, the informations you have are not right.

Example of such softwares: https://www.eversql.com/top-5-mysql-gui-tools-for-windows/

As an example here are my settings for MAMP server:

Server address: 127.0.0.1
Database name: prestashop (I created it so I gave it this name)
Login: root
Password: root

This is a setting for debug (as you can guess from the insecure password) only

[Peter Pastoor]

Thank you for your answer.

I have created a new database and account 3 times. Only on the third time everything went well. I think something went wrong with the hoster.

[globalainope]

Me too. My install error is can't find database username, etc.  What should i do ?

[SamTTT]

Try using localhost as Database server address
And root as Database password

Works on Mac when I use MAMP.

See images attached

 

[Lajos]

After first install, localhost worked just fine. Then for other reasons I had to re-install my Prestashop and although nothing changed (besides PHP version) it did not want to connect to my db anymore. I tried 127.0.0.1 but to no avail. Then at my host webpage under database settings I found the server address which is supposed to work from everywhere, in my case (note that I also had to specify the port):

mysql57.websupport.sk:3311

I still don't know why localhost doesn't work tho.

[Nickz]

On 5/1/2021 at 1:26 PM, Lajos said:

I still don't know why localhost doesn't work tho.

Could well be an permission issue