Issue Server Error 500 Plesk\Exception\Database

[fvs047]

Server operating system version

Almalinux 9.5

Plesk version and microupdate number

v8.0.68

Hello all,

I recently attempted to move my /var/lib/mysql folder to another disk on my machine that has vastly more storage.
However, after doing so, i got the following error when trying to access the admin panel.

Server Error

500 Plesk\Exception\Database​

DB query failed: SQLSTATE[HY000] [2002] Permission denied

Type	Plesk\Exception\Database
Message	DB query failed: SQLSTATE[HY000] [2002] Permission denied
File	Mysql.php
Line	79

I ran the plesk repair tool via CLI and it came back with OKs.

Anything else i might have missed here?

I have tried the following:

chown -R mysql:mysql /var/lib/mysql
chmod -R 750 /var/lib/mysql

Thank you in advance guys!

 

[Bitpalast]

Is SELlinux on?

 

[Raul A.]

Is the MariaDB service running? Where is the datadir and do you have the psa db in that dir?
You can find the datadir by running

select @@datadir;

 

[scsa20]

Please note that moving the database to a different location is not officially supported but if the new disk is mounted at /var/lib/mysql then it should be fine as long as the permissions are set properly. You can check https://support.plesk.com/hc/en-us/...ct-Permission-denied-var-lib-mysql-mysql-sock for setting permissions

Basically, since you're using a RHEL based OS, make sure that /var/lib/mysql permissions is set to 755.