ERROR MariaDB is running but PID file could not be found

Code: [Select]

# service mysqld status
 ERROR! MariaDB is running but PID file could not be found
I believe I need to add something like the following to my /etc/my.cnf file.

Code: [Select]

[mysqld]
pid-file = /path/to/where/PID/file/should/reside/mysqld.pid
But... I don't have any idea where the right place is to locate the PID file.

...and with CWP running MariaDB rather than mysql, should the PID file be "mariadb.pid"

hello,

yes you need to paste this in /etc/my.cnf after creating /var/run/mysqld/mysqld.pid with proper permissions.

[mysqld]
pid-file    = /var/run/mysqld/mysqld.pid

i had the exact same issue and it waas resolved after the above steps, but after this i was not able to view any mysql databases under cwp pro admin and user control panels .

does anybody know how to fix database view issue after fixing the above pid issue in cwp pro? kindly share the workaround if you know.

Regards,

Zeeshan Javed