Tag Archives: Databases

Hi, It looks like mysql (10.1.37-MariaDB, WHM v76.0.18) doesnt accept max_open_files set in my.cnf I have: ShareTweetPostPin It!

Hello, forum members! I’m Archana Shah, and I’m currently dealing with a database problem in cPanel that’s impacting the functionality of my https://www.pipes-tubes.com. This issue has been causing quite a headache. I’ve attempted various troubleshooting steps, including checking database configurations Continue reading Database Issues in cPanel for my website→

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 Continue reading Random Database Errors Following MySQL Governor Uninstallation and MariaDB Upgrade→

Using mariadb 10.3 on my server. some of my websites needs Utf8mb4_0900_ai_ci collation. unfortunaetly its not found in my server. how to add it ShareTweetPostPin It!

Hi, I installed Cpanel and I spent much time to configure it, But after installation and configuration I found that CPanel installed MySQL 8 as default for database ShareTweetPostPin It!

As I have many times before, I just logged in to user’s cPanel to delete a no longer needed database, it seemed successful, and I removed the DB user as well. But then the database (with no user) mysteriously came Continue reading There was a problem deleting the database→

Hello, I am a total idiot and hit update while not understanding how MySQL works, the only thing I can barely figure out is creating subdomains and uploading some files via cpanel. Please help me reverse or finish the update? Continue reading MySQL 5.5 -> 5.7 Update problems Help Required→

Hello, I’m reaching out because I’m unable to add .sql files to phpMyAdmin. The website loads for a good 5 minutes before crashing with this error. Any ideas? I’ve tried resetting the SQL settings, but it doesn’t seem to help Continue reading PhpMyAdmin Error 500→

Hell everyone, I just wandering if anyone can help me. My administrator of my forum thinks our cPanel has been compromised but I am not sure. ShareTweetPostPin It!

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 Continue reading Should it be safe to migrate all accounts from MariaDB 10.3 to MySQL 8 in a shared hosting environment?→

Hello Does anyone know if it is possible to have two website folders in public_html of the same Cpanel account use the same (1) database? The reason for this is while one site is running live a copy of the Continue reading 1 Database, 2 Websites→

I need to migrate one server to another server. the source server has mariadb10.2 and the destination has 10.3. So can I migrate this.?? Unfortunately, i cannot upgrade the source server to 10.3 ShareTweetPostPin It!

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? ShareTweetPostPin It!

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 Continue reading How to load MariaDB 10.3 on a WHM system with MySQL 8.0?→

Hi, I am using the WHM gui to upgrade MySql 5.7 –> 8.0 but get the following error message when running the upgrade checker utility – see image attached. Additionally in the mysqld.log file the following has been logged: ShareTweetPostPin Continue reading Upgrading from MySql 5.7 –> 8.0 Problems→

I notice on this page: https://support.cpanel.net/hc/en-us…ons-of-MySQL-and-MariaDB-does-cPanel-support- …that MariaDB 10.11 is supported by cPanel on both AlmaLinux 8 and CloudLinux 8. I’ve got one of each of the above servers (and other older ones too), but MariaDB 10.11 is not yet Continue reading How to make MariaDB 10.11 available on supported OS?→

Hi, How to turn event_scheduler on ? +——————-+ ShareTweetPostPin It!

I’m getting closer to upgrading from MariaDB 10.3 to either 10.5 or 10.6 on a couple of busy shared servers, one running CL 7.9 and the other CL 8.8. Assuming that: 1. We’ve taken all the normal precautions, like backing Continue reading MariaDB upgrade from 10.3 to 10.5 or 10.6?→

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 Continue reading root, mysql, mariadb.sys gone from mysql.user→

Hi there, I’m under an Almalinux system and an user of Cpanel, and I’m aware of the rule : “We only support versions of PostgreSQL that you install with the /usr/local/cpanel/scripts/installpostgres script.” ShareTweetPostPin It!