Author Topic: ERROR MariaDB is running but PID file could not be found  (Read 10269 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
ERROR MariaDB is running but PID file could not be found
« on: September 11, 2019, 12:33:25 AM »
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"

Offline
*
Re: ERROR MariaDB is running but PID file could not be found
« Reply #1 on: May 02, 2020, 05:20:20 PM »
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
« Last Edit: May 02, 2020, 05:36:01 PM by zeejdeej »