Xampp Local Server Error - Link to database cannot be established

[rs-prestadev]

Hi,

I 've been working on a local Xampp install to dev a new PS theme, everything worked fine until this morning when I started the server again. I can't acccess the front (nor the admin), I get the following 500 error:

Link to database cannot be established: SQLSTATE[HY000] [1044] Access denied for user 'prestashop'@'%' to database 'prestashop'
at line 127 in file classes/db/DbPDO.php

I'm running on 1.7.6, I checked my database parameters in parameters.php, and everything worked properly before. The only thing I did was change some products yesterday (for the first time), but everything worked until I started the server today.

I've googled the issue but nothing comes up, does anyone have an idea on how to handle this ?

Thanks

 

[fbenoist.com]

Hi,

Did you check if mysql (or mariadb)  is running properly ?

[rs-prestadev]

It seems so... (I tried a restart as well, no effect)

[fbenoist.com]

Check database_host in /app/config/parameters.php and try to replace 'localhost' with '127.0.0.1'

[rs-prestadev]

That's my current setting :

[fbenoist.com]

You may have to try with another user to verify that this is a user rights issue.

[rs-prestadev]

Okay, works with root, so it's a user issue...

when I check my prestashop user privileges, I get this a MySQL checksum error, is that my issue ? How can I handle this ?

Thanks ! 

[fbenoist.com]

Try to repair database, see https://stackoverflow.com/questions/58765779/mysql-issue-when-creating-a-new-user