After using Plesk to upgrade Mariadb from 10.5 to 10.11 Wordpress and other apps can no longer connect to 'localhost'

[efisher@]

Username:

TITLE

After using Plesk to upgrade Mariadb from 10.5 to 10.11 Wordpress and other apps can no longer connect to 'localhost'

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Plesk 18.0.58, Almalinux 9.3, x86_64

PROBLEM DESCRIPTION

I know I took a big risk to use the new beta feature in Plesk that juust released to upgrade my Mariadb instance to the latest, 10.11. All went well, but afterwards, Wordpress is no longer able to connect to 'localhost' for the database.

If I change the DB_HOST to the host name or to 127.0.0.1 it works fine. I know that 'localhost' has a special meaning to MySQL derivatives, but not sure what would have changed between 10.5 and 10.11 to break Wordpress connecting to 'localhost'.

STEPS TO REPRODUCE

Upgrade Mariadb from 10.5 to 10.11 using new 'beta' feature in Plesk

ACTUAL RESULT

After upgrade, Wordpess gives a permission denied error connecting to the database.

EXPECTED RESULT

Permission should be granted to both localhost and 127.0.0.1

ANY ADDITIONAL INFORMATION

(DID NOT ANSWER QUESTION)

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Help with sorting out

 

[Dave W]

show your /etc/my.cnf file and /etc/resolv.conf

 

[Peter Debik]

Duplicate to Issue - Latest 'beta' feature to Plesk to upgrade Mariadb is giving problems