database

  1. L

    Auto routine check database connection

    All websites on my server this morning were reporting "Error establishing a database connection". I rebooted the server through WHM and everything came back online - I assumed it was caused by an automatic update to WHM version 96.0.13 - 2021-07-19 [security] TSR-2021-0004. Is there a setting...
  2. H

    Database Restorations

    i need to restore one database from one server to new server with new username. For Eg: Existing database name like cpanelusername1_dbname.sql. i need to restore the content of these database to new server with cpanelusername2_dbname. Is this possible.
  3. A

    Urgent mysql stopped working after importing a database

    Hello, i have imported an database via this command : mysql -u root < all_databases.sql after it, everything stopped working. WHM >> phpmyadmin this is also not working. cPanel's phpmyadmin also not working. mysql server is offline. in whm >> phpmyadmin i am getting this error ...
  4. Ekushey

    Roundcube database type

    I need to transfer a single cPanel account from one VPS to another. Source is running cPanel 86.0.40 while target running 96.0.11. While I attempting to transfer using the Transfer tool, I get the following message: Source: “x.x.x.x” Roundcube database type is “mysql” … Target...
  5. H

    Move or duplicate database

    Hello dear, today I have the following question, I want to move or duplicate a database from user1 to user2 the database is very large and it is I need to have this database in another account / another user always from the same server user1 -> BD move or copy it to user2 if this is not...
  6. D

    Random error establishing connection to database on 3 websites

    Hello On 3 websites I have running on a WHM server using cPanel over the last few weeks I have an "error establishing connection to database". This error has appeared out of the blue with nothing being done to any of the websites as they are all brochure sites.. They instantly fixed...
  7. D

    User couldnot add to database

    I cannot add user to database. I tried by creating user and database in MySql Database Wizard and database and user is created successfully but at last it shows Error ID: ww9ydv. When I tried to add manually in MySql Databases, its same issue there.
  8. Michael Legg

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

    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...
  10. 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...
  11. 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.
  12. D

    wordpress: The MySQL Database could not be selected

    I'm installing the wordpress and with the database but unable to do it.
  13. 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...
  14. 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...
  15. D

    SOLVED Database Error.

    Hi, When I click on databases in cPanel, such error appears. MariaDB 10.3
  16. 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...
  17. 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...
  18. 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
  19. 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...
  20. 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...