database

Hi Guys We've just had to change our local network address range and we have a separate MariaDB database server. I logged into mysql and updated all of the hostnames in mysql.user and ran FLUSH PRIVILEGES, but the web sites still can't connect to the db server. I also tried to update the...

I have gotten this error twice now... WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like' for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships AS tr ON...

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 back a couple minutes later while I was working in the user's cPanel. Tried...

I'm unable to add user to the database. When I do all privilege and do make changes, it keeps loading for sometime and stops. When I go back, it is not added.

I'm installing the wordpress and with the database but unable to do it.

Hello, When you click on manage databases from the list on the left (main cpanel home interface) .. it doesn't show all databases on the system. I'm guessing it only shows databases activity tied to an account. However, if you use the transfer tool and transfer a site, and it messes up in...

Hi! I did not find any answer in the forum yet for what I wish to do. We have an external system that backups our entire machine, which allows us to restore the full machine, or access individual files. In that sense, we do not need to backup the accounts, nor the system. But for backups to...

Hi, When I click on databases in cPanel, such error appears. MariaDB 10.3

Hello team and everyone, I'm system admin in Vietnam. I just migrate all accounts from old server named h1.mydomain.com.vn to the new server named test.h1.mydomain.com.vn. The domain test.h1.mydomain.com own its cPanel SSL. So I need to change the hostname on new server to h1.mydomain.com.vn...

Roundcube - sqlite DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator. I got this error for a few accounts only and after migrate from a server with roundcube in mysql all accounts migrated with transfer tool. New server have sqlite...

Hi, i want to add Geolocation db in modsecurity config... looking to the description: so it appears ModSecurity accepts only GeoIp v1 format in the maxmind i found only Geoip2 database... any suggestions please??thanks a lot

Hello, we are considering to shut down the PostgreSQL Database Server to try and save memory and resources. It seems PostgreSQL is not very popular. Before we disable PostgreSQL on our server, how can we find out if anyone is actually using it? Is there a way to see if any user has created a...

Hello guys. Today, sudenly one of the servers showed this error when trying to access Roundcube from any of the accounts. DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator. My current server: CENTOS 7.8 kvm cPanel v90.0.10 mariadb...

Hi, I have a server with disk quota problem, I removed old databases but when use command "df -h" not appear the new free disk quota. -Before remove database: df -h / -> 94% -After remove database (I calculated should get 2.5%): df -h / -> 94% too Why happened?. Too I used the command "lsof...

Hi, I am Monowar Hossain and i am a new user. I face following problem 1. The Mysql server id currently offline. 2. DBDISKUSED How do i solve this problem

Hey everyone, We wanted to let you know that we have become aware of an issue updating from MariaDB 10.3.22 to 10.3.23. This is being shown to break the cPanel -> MySQL Databases interface. This MariaDB update occurs automatically when updating cPanel with a version that includes support for...

my PostgreSQL server is very trouble, before done fix install PostgreSQL many times step The Postgres database is not initialized. The system will now initialize it.Los archivos de este cluster serán de propiedad del usuario «postgres». Este usuario también debe ser quien ejecute el proceso...

Bonsoir Est ce que je peux installer le serveur hfsql dans mon serveur vps (cpanel) ? Merci Aziz

i'm looking at the Databases section of the documentation for WHM Backup Configuration. It lists three options for database backups: Per Account Only — Only back up the databases for each account. This setting uses the mysqldump utility. Entire MySQL Directory — Back up all of the databases on...

One of my user wants to run a educational firm Script on my hosting, his script working fine in Hostgator and godaddy but in my Server he is facing issues of %)) Internal Error. he is trying to access from localhost:8000 but i think i had blocked access of 127.0.0.1 ports because WHM Security...