Vesta Control Panel - Forum

I'm moving to a new vps host, old vps host has Debian 8. After clean Vesta install, i restore from backup and run mysql_upgrade. No issues with non db sites but all joomla/wp sites have " Error establishing a database connection". Cant figure out why. I can restore the same backup file to new host and as long as its Debian 8 everything just works after restore command, but not with Debian 9. I'm 100% sure it has to do with MariaDB Debian 9 using but as far as i know its a direct replacement and should just work.
Tried changing "localhost" in config files to IP, and even [::1], nothing works. Whats really odd is that if i go ahead and change DB password for one of the sites and then plug in new password into wp config file, it will load fine BUT if i do this to other sites i get "http error 500".
Its not the end of the world for me, ill just install Debian 8 on new host but i want to know why this is happening and how to make this work. Since i'm migrating, might as well use Debian 9.

What version your run in debian 8

Maybe you have mysql 5.7 ?

Maybe your backup not store passwords in vesta conf file as old issue with mysql 5.7 -> viewtopic.php?t=13239

Check if your db.conf store your password /usr/local/vesta/data/users/YOURUSER/db.conf

Also unzip backup and check if there are passwords

With error 500 I can say nothing, you need check logs, maybe php version, maybe something more