mysql

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...

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...

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...

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...

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...

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?

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...

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...

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

How to backup MYSQL and public_html regularly inside CloudLinux?

How to restore MYSQL 10 days ago using CloudLinux?

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...

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...

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...

<redacted by user>

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

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

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...

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...

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...