SOLVED MySQL database Error cause of cpanel_cp

foxmedo

Active Member
Apr 21, 2014
39
1
58
cPanel Access Level
Root Administrator
Dears,

we have a problem today, most of user clame that they have a problem with the database

when we restart the MySQL it back to work i have check the sevice status i find it up but when i have restart i get this log message

Code:
Log Messages
2020-06-05T19:21:52.868929Z 0 [Note] /usr/sbin/mysqld: ready for connections.
2020-06-05T19:21:51.720431Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2020-06-05T19:21:50.127367Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 9697 user: 'cpanel_cpguser'
2020-06-05T19:21:50.127358Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 9293 user: 'cpanel_cpguser'
2020-06-05T19:21:50.127350Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 8824 user: 'cpanel_cpguser'
i have try mytop in ssh
Code:
MySQL on localhost (5.7.29-cll-lve)                                                                                                          up 0+00:04:52 [20:26:44]
 Queries: 116.0  qps:    0 Slow:     0.0         Se/In/Up/De(%):    00/00/00/00
             qps now:    0 Slow qps: 0.0  Threads:   10 (   1/   3) 00/00/00/00
 Key Efficiency: 99.0%  Bps in/out:   9.0/ 2.2k   Now in/out:   8.4/ 2.2k

      Id      User         Host/IP         DB      Time    Cmd Query or State                                                                                       
      --      ----         -------         --      ----    --- ----------                                                                                           
       6      root       localhost      mysql         0  Query show full processlist                                                                                 
     335 *******_w       localhost *******_wp         0  Sleep                                                                                                       
     361 ********_       localhost ********_m         0  Sleep                                                                                                       
     362 ********_       localhost ********_m         0  Sleep                                                                                                       
     368 ********_       localhost ********_m         0  Sleep                                                                                                       
      18      root       localhost informatio        33  Sleep                                                                                                       
     273 cpanel_cp       localhost cpanel_cpg        43  Sleep                                                                                                       
     197 cpanel_cp       localhost cpanel_cpg       103  Sleep                                                                                                       
     148 cpanel_cp       localhost cpanel_cpg       163  Sleep                                                                                                       
      67 cpanel_cp       localhost cpanel_cpg       223  Sleep
i have searched in google to get more infor about cpanel_cpg & cpanel_cp but i didn't find any information about
 

cPSamuelM

Technical Analyst Team Lead
Staff member
Nov 20, 2019
196
38
103
USA
cPanel Access Level
Root Administrator
Hello @foxmedo

Thank you for contacting cPanel! The cpanel_cpguser MySQL user appears to be associated with the 3rd party plugin "cPGuard." For more information, refer to their website:

https://www.opsshield.com/

Best regards