Control Web Panel

WebPanel => MySQL => Topic started by: DA_MAN on September 11, 2019, 12:33:25 AM

Title: ERROR MariaDB is running but PID file could not be found
Post by: DA_MAN 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"

Title: Re: ERROR MariaDB is running but PID file could not be found
Post by: zeejdeej 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