1. H

    [ERROR] mysqldump: Error 2013: Lost connection to server during query when dumping table

    Hello, I use Current Version MariaDB 10.6.12-MariaDB During the process of backing up all sites All copying operations succeed except for one site that shows this error while copying the database [ERROR] mysqldump: Error 2013: Lost connection to server during query when dumping table...
  2. M

    Any repercussions if disable Force short prefix for MySQL?

    In an effort to to avoid submitting a possibly unnecessary ticket to the cPanel support team, I'm checking here first to see if anyone is willing to share their experience. I've been using the following settings for years now: In Tweak settings - "Require a username prefix on names of new...
  3. R

    Unable to update from mysql to mariadb

    Hi, i have install a cpanel on new server and want to move on mariadb but whm showing only one option MySQL 8.0. It is not showing other version of mysql and mariadb. How can i move on mariadb?
  4. K

    AlmaLinux 8, MySQL 5.7 and PHP 7.4 (or earlier)

    Howdy! I understand that cPanel & WHM version 110 will be the last version that supports CentOS 7, and support for version 110 will end June 30, 2024. I am presently running CentOS v7.9.2009 STANDARD virtuozzo . I also understand that as of this time the Elevate to AlmaLinux 8 script does not...
  5. lionsgate

    Reported MySQL Version

    Via WHM :: Security Center :: Security Advisor, I see this: You are using MySQL 5.7 server. This version is not available for AlmaLinux 8. You first need to update your MySQL server to 8.0 or later. You can update to version 8.0 using the following command: /usr/local/cpanel/bin/whmapi1...
  6. R

    mySQL high ram usagw

    Hi mates, Please help to optimize my mysql to reduce ram loads
  7. PCZero

    SOLVED lost root access to MySQL - DFU error...

    I was attempting to added authorization for root to access MySWL remotely from my IP using MySWL Query Browser 1.2.17. I was successful by chaning the Host field form localhost to my current IP, then I was successful using the wildcard "%". I wantd to make it so that only localhost and my...
  8. G

    Tracking logins to MySQL, potential breach

    I've had 21 instances of 11 existing users having an unauthorized login from a specific non-US IP address, starting on January 15. At first I thought they might be using the same VPN software or something, but twice the user tried to submit obvious spam through a form. That makes me concerned...
  9. M

    DO NOT transfer from MariaDB to MySQL

    We are trying to migrate from a 60+ account server: CentOS 7.9 cPanel 106 MariaDB 10.3 To a new server with: AlmaLinux v8.7 cPanel 106 MySQL 8.0 Assuming that since MySQL is the default option for new cPanel installs and MariaDB option is no longer present, it would be a better tech stack for...
  10. charliecres

    Mysql database error

    facing this error after importing an SQL file to my server, but this SQL file working perfectly on another server! Note: (Server version: 8.0.31-cll-lve - MySQL) I have attached a screenshot for better view.
  11. A

    Mysql folder in full backup is empty

    Hey guys I have two servers that cpanl have been installed on both, Manual and automatic backup work perfectly in one server but backup doesn't work properly in another one. In one of servers Mysql folder is empty (in full backup) and when I try to download Mysql via "Download a MySQL Database...
  12. J

    How delete large file server.log?

    Hi, on the VPS with cPanel the space has been reduced to the point that on an 800 gb SSD there are only about 100 gb left, so it is occupied for about 87%. Analyzing the various files and folders I noticed that in the /var/lib/mysql folder there is the server.log file which occupies about...
  13. jimjoe

    MariaDB upgrade needed for Kernel update - but I must keep php 5.6

    I MUST keep php 5.6 on my server, or I'm out of business, but now I see that kernel won't upgrade on MariaDB 10.2. What higher version of mariadb will still work with php 5.6? Is there a way to test to confirm if php 5.6 site will work with any mariadb upgrade before making it permanent...
  14. A

    MySql TLS version wannings

    Hello, MySql server is showing following wannings. A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. CA certificate ca.pem is self signed. I checked for updates and it is stating mysqld 5.7.40 and saying all packages are updated. Please help me fix this issue...
  15. L

    error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

    I had: PHP Version 7.4.33 and WordPress 5.9.5 Updated WP 6.1.1 >>> Updated to PHP 8.0.25 Success: Successfully applied PHP version “PHP 8.0 (ea-php80)” to the selected domain. >>> PHP Version 8.0.25 >>> I have gone to the WP home Blog home page and: Your PHP installation appears to be missing...
  16. tbutler

    SOLVED New Server Stuck on MySQL 8, Not MariaDB

    I'm preparing to migrate to a new server my datacenter just provisioned. My current cPanel server is running MariaDB 10.3, but as threads such as this one talk about, cPanel now seems to default to MySQL 8 during installation, which makes installing MariaDB impossible. I'm concerned on a couple...
  17. leonep

    mysql error on log access denied

    Hello, i have a lot of notice entries in mysqld.log. i tried changing the password from whm as well but it keeps flooding my log where can i look for responsible for this? ............luckily everything is ok and running on the server ! 2022-11-24T20:35:53.233369Z 671 [Note] Access denied for...
  18. charliecres

    MYSQL server getting slower

    MYSQL server getting slower and most of the site showing down. i need to restart mysql server once to solve this issue in every 12-15 hours. i need a permanent solution. is there any way to restart mysql server automatically in every 12 hours? or any cron job setup? i have included...
  19. Q

    cPanel / WHM Mysql offline

    Good afternoon, I wanted to ask the help of the friends of the forum! I currently have a cpanel/whm server with cloudlinux 8.6.0, and Database MariaDB 10.5 I'm having a problem with my database, it's suddenly going offline, to get back online I have to go online again. but this is happening...
  20. F

    High Mysql loads always on wordpress sites (Above 200%)

    My server shows more than 200% CPU load on Mysqld ( /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/ ) Total server load in peak hours with just a 1000 users online (above 20%), after this sites are slow and unresponsive. I have hired 2 cpanel management companies to optimize...