database

  1. Michael Legg

    New Thread Update Separate Database IP Address

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

    Database Error Illegal Mix of Collations

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

    There was a problem deleting the database

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

    Unable to add user to database

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

    wordpress: The MySQL Database could not be selected

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

    bugreport: manage databases doesn't show every database on system

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

    Database backup ONLY -- Per Account Only

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

    SOLVED Database Error.

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

    SOLVED RE-UPDATE SSL cPanel FOR HOSTNAME SERVER

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

    Roundcube - sqlite DATABASE ERROR: CONNECTION FAILED!

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

    ModSecurity Geolocation Database Setup

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

    How to know if anyone has a PostgreSQL database?

    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...
  13. Kent Brockman

    Roundcube database error

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

    Urgent: removed database but not get disk quota

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

    Mysql database

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

    SOLVED [CPANEL-32712] Updating to MariaDB 10.3.23 on cPanel breaks the MySQL Databases interface

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

    PostgreSQL Server

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

    HFSQL

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

    SOLVED Database Backup Options

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

    Facing Some issue regarding PHP Script

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