1. B

    MySQL service going down regularly

    I keep getting notification emails for failed mysql service or mysql service down. This is happening like a couple of times a week. The email includes messages like these: The email indicates serveral tables marked as crashed like this message: The service seems to automatically recover...
  2. behinam

    could not be added to the database The request failed

    When I want to add a database to the user I give this error: could not be added to the database aaa_bbb”. The request failed. (Error ID: rcyg25) Ask your hosting provider to research this error in cPanel & WHM’s main error log. in Cpanel log show this error: Error from MySQL query: (XID...
  3. K

    Mysql refusing remote connection over vpn

    I've been using the remote access hosts feature on cpanel for awhile to remote into one of our mysql databases on a dedicated server we own. I have a few hours a week I'm on a VPN (expressVPN if it matters) and for some reason even after I enter the IP address and/or IP address range it won't...
  4. T

    New client needs mysql_* in 5.6 to function briefly

    I know, the new client is in the process of moving to PDO, BUT is being forced by web host to migrate to new VPS prior to PDO completion. I just got pulled into this today. I put PHP 5.6 on the new server but the mysql library seems not to be installed. Site is getting Fatal error: Call to...
  5. P

    MySQL Terminates Due to Memory Despite Only Using Half

    I got an error saying that the mysqld service was terminated due to lack of memory but then gave the memory usage as: Status Out of Memory ⚠ Memory Information Used 7.65 GB Available 8.02 GB Installed 15.67 GB Shouldn't the amount of memory used be at least close to the maximum...
  6. K

    In Progress CPANEL-41370 - remove Remote Mysql link and icon from cpanel in jupiter

    How can we get rid of the the Remote MySQL icon and link in cpanel when we use jupiter? We do not allow remote mysql. Was no problem getting rid of all icons and links in cpanel interface we did not need, in paper lantern, but how can we do it in jupiter?
  7. C

    Mysql large number of running threads, causing hangs

    Hello, I'm trying to figure out a weird mysql issue. We have a cpanel server running mysql 8.0.30 which works fine but every once or twice a day, mysql becomes unresponsive or painfully slow. RAM, SWAP, IO usage increases but CPU is fine. Upon checking, # mysqladmin status Uptime: 27795...
  8. P

    Too Many Connections in phpMyAdmin and Sites Offline

    I have been having a problem the past 24 hours. My sites display errors that they cannot connect to the database and when I try to use phpMyAdmin I get mysqli_real_connect(): (08004/1040): Too many connections I tried setting the max_connections to 300 because my research indicates that...
  9. J

    How to add remote MySQL for only one account

    Folks, I have one customer who wants to use MySQL 8.0. All the others use MySQL 5.7. I use AWS, so I could provision a second server just for MySQL if that is the best option. Thanks, Jim
  10. T

    How to backup MYSQL and public_html regularly inside CloudLinux?

    How to backup MYSQL and public_html regularly inside CloudLinux?
  11. T

    How to restore MYSQL 10 days ago using CloudLinux?

    How to restore MYSQL 10 days ago using CloudLinux?
  12. C

    MariaDB Upgrade from 10.5 to 10.6 Failed

    I tried to upgrade mysql but the upgrade failed. My upgrade steps and the error log is below. Initially my site was totally down and throwing 500 errors, and I ran this command which brough it back up: mysql_upgrade -u root -h localhost -p --verbose --force The web site seems to be fine, and I...
  13. charliecres

    error establishing a database connection after upgrade mysql to MariaDB

    Last Night I upgraded MySQL to MariaDB 10.5. Currently, i am using cloudlinux. Now I am facing an error issue" error establishing a database connection"| after per 10-20 minutes it's getting this error for 1-2 minutes. I have tried to fix this. but unable to fix this issue. so need help to...
  14. M

    All server web traffic lagging out when server load hits around 2.5 2.5 2.5

    I've had a cpanel server running on an eight core VPS for many years. I am migrating to a new server in a different data center due to server stability issues (data center keeps having "fires" and crap)... The new server according to its specs is slightly more powerful than the old setup. 8 x...
  15. F

    Search throught ALL MYSQL databases in WHM

    Hi, I need a script that search throught ALL MYSQL databases in WHM, inside all wp_users tables, if there is a user with is called "XXXXX" Is there anyway to do it using WHM CONSOLE or using WHM Root's PhpMyAdmin ? Thanks, Francisco
  16. S

    Mysql resourse

    Hello! in mysql there are many processes that eat up all the memory. Is this a possible attack? I am attaching screenshots.
  17. J

    MySQL 8.0.29 - Woocommerce InnoDB corruption

    Hey, Just to let you know there is ongoing bug with MySQL 8.0.29 that is causing silent InnoDB corruption mainly with Woocommerce updates. Some info is here MySQL :: Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29 Oh and little info. This will cause MySQL to crash...
  18. J

    MySQL Service Status shows down while the service is running

    One of our customer's cpanel boxes is running v.104.0.3 on Centos 7.9, system PHP is 7.4. They elected to upgrade MySQL to MariaDB 10.3 a couple of months ago. No issues until today when we started getting email alerts about MySQL being down. Logged into WHM, restarted mysql...
  19. N

    csv cronjob to import in mysql database table

    Hello, I am having a CSV daily sent via ftp to my public_html folder on a website. I am trying to make a cron job to import it into database called "grijanjetuzla_stanjeracuna" in table "saldo" , and delete records in table "saldo" it next day so I can import it again with fresh data. This is...