Error establishing a database connection

[romanv]

I migrate cpanel user to myvesta and client have this error on his site: Error establishing a database connection

Password is correct. I try to login in phpmyadmin via user and it's work. But site is down.
Check permissions in mysql and user have all privileges on his database.

Vesta host
Vesta version: 0.9.9-0-4
OS: Debian 11.7
DB: Mysql 8.0.33

Cpanel host
cpanel version: v86.0.40
OS: CentOS 6.10
DB: MariaDB 10.0.38

Migrate via cpanel backup and restor via v-import-cpanel-backup.

[myVesta]

maybe in wp-config.php, define for DB_HOST is not localhost ?

[romanv]

maybe in wp-config.php, define for DB_HOST is not localhost ?

In wp-config.php set: define('DB_HOST', 'localhost');

[myVesta]

And with the DB username and password from wp-config.php, you can login with phpmyadmin?
I have no idea then... see if something comes up in Error log.

[myVesta]

By the way, PHP lower than 7.4 can't connect to mySQL 8.
What PHP version you set to that domain?

[romanv]

By the way, PHP lower than 7.4 can't connect to mySQL 8.
What PHP version you set to that domain?

Client have php 5.6

[romanv]

How can i change mysql 8 to mariab without reinstall vesta on debian 11?

[myVesta]

Pretty hard... you need first to remove mysql8 totally, then to install mariadb as vst-installer-debian.sh would install it... then to rebuild all databases, and finally to import databases dump you made before deleting mysql8.