Problem with connection database.

[rizwan0237]

I made database with the same name as shown in attached photo, but it's not connecting.

I am trying many times but it's not resolve.

I am using windows 7 , xampp.

 

Somebody help me.

 

[PrestaServicePro]

Hello, 
Open xampp and check MySQL port and maybe changed default port.
Add "root" to passwords fields.
Then check the connection.
 

[rapidoLopez]

Hi @PrestaServicePro!

I think I'm having same problem as author of this post. 
So phpMyAdmin database service have new user with all privileges to manage new database: "prestashopdb". Below console log from this operation:

CREATE USER 'prestashopdb'@'localhost' IDENTIFIED VIA mysql_native_password USING '***';GRANT ALL PRIVILEGES ON *.* TO 'prestashopdb'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS `prestashopdb`;GRANT ALL PRIVILEGES ON `prestashopdb`.* TO 'prestashopdb'@'localhost';

PrestaShop wizard is filed as below, unfortunately test fails, without specific tip in error box:

I've tested connection to this database with php code 

$conn = new mysqli($servername, $username, $password);

and it ends successfully. Changeing port of MySQL did not help.

Any idea whats here wrong?

[rizwan0237]

I searched too many thing and apply but it's not resolve. 

Someone tells me that new prestashop version didn't support php 8.0

[PrestaServicePro]

Hello, 
Check image of PS requirements:

 

[rapidoLopez]

Hi  @rizwan0237 

The answer is, as @PrestaServicePro posted; check your server php version vs prestashop requirments! In my case it was PHP8. Prestashop is not ready yet for this version (probably will be at the end of this year)