1. W

    how to connect between managed database

    I want to take advantage of an external managed database (similar to AWS RDS). I understand it's possible with cPanel server. I also want to be able to use phpmyadmin to manage the external database. Can you please offer some tips / guidance on doing that?
  2. A

    Transfer Tool does not copy database user name in transfer tool

    Hello, We are migrating accounts from DirectAdmin to cPanel from Transfer Tool. The problem we are facing is database user's name is not coming completely. For example, in DirectAdmin if the database user's name is bestvideostatus_265 then in cPanel it will be as bestvideostatus_2 The...
  3. S

    Migrate database from shared hosting to AWS Lightsail with WHM

    Hi, I face a prblem for migrating a database around 200mb from shared hosting to my own AWS Lightsail with WHM My current shared hosting disable backup function in cPanel. I can only export it from phpmyadmin or request provider to do it. after i download the backup file, how do I import it...
  4. R

    Random Database Errors Following MySQL Governor Uninstallation and MariaDB Upgrade

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

    Access denied for user in backup

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

    Mysql Database restore / reinstall / rebuild CentOs Cpanel

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

    change cpanel /whm database port 3306

    Good afternoon, I'm facing problems on my cpanel whm server at ovh, I'm suspicious that I'm taking ddos attacks on my server on port 3306 referring to the database, so I want to change this port to one of my choice. How do I change database port 3306 in cpanel whm panel, could anyone help me...
  8. U

    MariaDB database files

    My server went down and hosting company issued me a new VPS, I had MariaDB version 10.7 on my server. I have a full Cpanel account backup, but where can I find MariaDB SQL database file of my wordpress website? I searched for /home/username/mysql but nothing found, after finding it how can I...
  9. L

    upgrade from mysql 5.7 to 8.0 failed because of an old database with utf8mb3 characters

    hi, I Upgraded mysql 5.7 to 8.0 and now after installation cpanel have removed version 5.7 and it only has 8.0 even when I want to install 5.7 again manually yum wont find files... anyway there is an old database with utf8mb3 characters in it . which innodb is giving errors about it and won't...
  10. H

    [ERROR] mysqldump: Error 2013: Lost connection to server during query when dumping table

    Hello, I use Current Version MariaDB 10.6.12-MariaDB During the process of backing up all sites All copying operations succeed except for one site that shows this error while copying the database [ERROR] mysqldump: Error 2013: Lost connection to server during query when dumping table...
  11. jimlongo

    path to sqlite

    when I ask /usr/local/cpanel/3rdparty/bin/sqlite3 --version I get 3.38.5 2022-05-06 15:25:27 serial when I use a db I have sqlite3 /usr/local/cpanel/whostmgr/docroot/cgi/xyz/Model/Db/database.sqlite and ask .version I get SQLite 3.7.17 2013-05-20 00:56:22 serial` how can I set 3.38.5 as the...
  12. icandoit

    SOLVED prefix before my database in phpmyadmin is this normal?

    Please see my wordpress database as you can see there is a prefix before my real database 2f0857_ I did not create this and in my wordpress config it is not there either however the site works find I can see this in phpmyadmin
  13. S

    In Progress CPANEL-42266 - Addon domain converter - database prefixes

    So with the Convert Addon Domain to Account - the database name and database user name prefixes don't change? Is that wise? If you ask me, that's a recipe for disaster later on. So if user1 has an addon domain - - that's using a database - user1_wp1 and they want to split...
  14. charliecres

    Mysql database error

    facing this error after importing an SQL file to my server, but this SQL file working perfectly on another server! Note: (Server version: 8.0.31-cll-lve - MySQL) I have attached a screenshot for better view.
  15. X

    Removing an account does not remove the database

    Hi, First time this happen but on a new Linux VPS when I remove an account using the command: /scripts/removeacct xyz and try to restore the same account /scripts/restorepkg cpmove-xyz.tar.gz I get this message during the process of restoration: The system will restore the database...
  16. F

    Cpanel transfer completed but cannot find database

    Hi, One of the accounts which was transferred via cpanel transfer tool does not show databases in the database section in cpanel(New Server). It says that the databases already exist as when i try to create these manually. I can see the DBusers and password but cannot see the databases. DO i...
  17. V

    Ubuntu fresh install mariadb database server

    Hello On our Ubuntu 20.04 server, we were able to use the mariadb server by adding the line mysql-version=10.5 to the /root/cpanel_profile/cpanel.config file, but this setting no longer works. I see an error during the installation phase and the installation does not continue; 2022-12-23...
  18. M

    The system failed to grant privileges on the database ...

    Hello, Just made a backup restoration of account and this appeared: Warning: The system failed to grant privileges on the database “new_db” to the user “new” because of an error: (XID ju8a2v) This system will not add the database user “new” to the database “new_db” because this user does not...
  19. ljj3

    In Progress CPANEL-41695 - Modsecurity Geo Database

    Is GeoLite2-Country-Locations-en.csv the file that ModSecurity needs to have Geolocation Database pointed to? I'm confused... My GeoIP.dat is very old, but the MAXMIND list of databases are al GeoIP2 which are not compatible with ModSecurity...
  20. N

    Change Database Server Name

    Hi, Previously I had a server that was hacked, and I saw a lot of mysql hostnames using And now I'm moving it to a 3x new server, but some cpanel accounts still display the huffingtonpost text on cPanel => Server Information (Server Name). Where can I edit the text? and...