mysql

Hi, We just moved to new server (centos -> cloudlinux) both are/were whm/cpanel. I have 4 big sites that all share access to a generic Geogrpahy database that converts ip addresses to locale, among other things. I have always had an anonymous user with select privileges to this db set up so...

Hi I have the following in my server: As you can see myql is hugging 40 Gigs in VIRT and 6 Gigs in RES. and free -mh shows this: so why is mysql using around 40 Gigs in VIRT? while in RES it is showing only 6 Gigs? how can I bring it down? I am using the settings below: I have...

I am planning to migrate a server running CloudLinux v7.9 and MySQL 8.0 to another server running MariaDB 10.x (preferably 10.6) using WHM Transfer Tool. Is it possible without problems due to compatibility issues with mysql 8 and mariadb 10.6? Thanks in advance for any help.

I'm trying to validate a new MySQL 8 Server running on AlmaLinux 9 and when I try to validate the profile, I get the error - Failed to “validate” Remote MySQL profile. 1 error occurred. The MySQL server uses the “caching_sha2_password” authentication plugin, which is not currently supported...

Hello, i am currently running Mysql 5.7 on cpanel/whm v110.0.7. I host a couple of websites and i am not sure they ensure 100% compatibility with Mysql 8. given the fact that mysql reaches EOL in a couple of days, i was wondering on how long i will be able to use mysql 5.7 for my frontend sites...

I didn't know that this was a thing until yesterday :-O https://cloud.google.com/sql?hl=en It would be $42 /month for me. The biggest advantages I can see, IF IT WORKS AS ADVERTISED!, is that it eliminates local problems that I have to fix, and (allegedly) faster processing time. And it frees...

Hi, after an error during update from CentOS7 to AlmaLinux 8 I lost completlly the Apache server. I installed it back, but now I am missing the MYSQL service with phpadmin. It is also missing in the Service Manager. Also the restart of mysql servis is gone. When I try to restart mysql service...

Hello everyone, I am encountering an issue with my database and need your assistance. Initially, I had MySQL Governor installed alongside MariaDB 10.5. I decided to uninstall MySQL Governor, which seemed to proceed without any issues. Subsequently, I navigated to the WHM menu option to upgrade...

I'm looking to change my backing-up process, mostly because the default cPanel system creates compressed files that are getting too big for my server's disk. If I understand correctly, incremental backups don't cause this issue because they don't compress everything into one file during the...

Can I transfer an account from a MySQL 5.7 server to one running MySQL 8?

Hello, I need to migrate a CentOS 7 server to Almalinux 8 using the transfer tool. Unfortunately I have forgotten to set the desired rdbms (it would have been MariaDB 10.4) and now it's too late (MySQL 8 came by default and can't change to MariaDB any longer). 1. Should it be safe (I don't...

When I run the /scripts/elevate-cpanel --check --upgrade-to=almalinux script, it identifies MySQL 5.6 as a blocker ... You are using MySQL 5.6 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...

Dear Sifus, Need help for solve my server MySQL issue, it keep down no matter how many time restart it But in SSH it showed active? I cant view my PHPMyadmin, it show " mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: YES)" below is my.cnf file ---------...

My server company has installed WHM with MySQL 8.0 and is not responding to my request to change this to MariaDB 10.3. Is it possible for me to do this? Is there a way to achieve this without a WHM reinstall? Can I just reinstall WHM from the current setup so that the DB server gets changed to...

Hi, After mysql have small error unable to login with root user all cpanel user access denied in log err mysql. I check from phpmyadmin these user not exist in table user mariadb.sys, root and mysql. I am try recreate/insert command but not work since mysql running with skip-grant-tables. I...

Recover MySQL data using software based on IBD or FROM. Hello community. After I tried to restore the broken mysql database using a new mysql. To do this I created and overwrote the .ibd file and ran the commands: (ALTER TABLE table_name DISCARD TABLESPACE;) (ALTER TABLE table_name IMPORT...

I have new servers that are forced to use MySQL 8.0. How can I migrate and restore accounts that currently use Maria DB MariaDB 10.6? There's no option that I can find to change Maria 10.6 to MySQL 8 Thank you!

Hello I was using a script for database backup when I used Centos + cPanel, but this script in Ubuntu + cPanel Runs with an error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user '-p'@'localhost' (using password: YES)' download script code URL...

Hello i need your help After turning off the server and turning it on again, my MySQL database no longer works. How can I revive mysql with ERROR 2002 (HY000)?: Scroll down for pics Root: systemctl status mysqld.service Also has mysql.sock only 0 bytes so the file exists but without...

I just got this today on a new server that has not been active for long. messages:Jul 31 15:14:12 main kernel: out_of_memory+0x1bd/0x4e0 messages:Jul 31 15:14:13 main kernel: Tasks state (memory values in pages): messages:Jul 31 15:14:13 main kernel: Out of memory: Killed process 1488 (mysqld)...