ERROR MariaDB is running but PID file could not be found

[DA_MAN]

Code Select Expand

# 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 Expand

[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"

[zeejdeej]

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