Resolved [Warning] Access denied for user 'username'@'localhost' (using password: YES)

[jamster1981]

Server operating system version

ubuntu 22.04

Plesk version and microupdate number

18.0.60

Hi Everyone,

I've already spent lots of time trying to figure this out from various articles but i'm having no luck.

Basically I've done a fresh install of Plesk on my vps, setup a website, added the database via import. PHPMyadmin works fine but whenever I try to load my website internal pages I get this error shown in the Plesk logs.

Can anyone please advise how to fix this.

Thanks

 

[Kaspar@Plesk]

Double check if database host, database user, database user password are correctly defined in website configuration. I recently spent way to much time on a similar issue only to discover that there wan an extra space behind te database user name in the in config file om my website

 

[ChristophRo]

Try using "127.0.0.1" instead of "localhost"

had way to much trouble with MariaDB > 10.6 on Debian/Ubuntu lately when using "localhost" (something to do with socket based connections and the "%" wildcard for access restrictions in mariadb no longer covers "localhost")

 

[Bitpalast]

Name resolution might be turned of in /etc/my.cnf.

 

[jamster1981]

it was my confusion. I have migrated 2 sites over and I was using the wrong database on this particular site lol