databases

I have some databases that were created by Wordpress Toolkit in cPanel which I cannot find in phpMyAdmin no matter what I do. I've tried logging into WHM as the root user and accessing phpMyAdmin that way which shows most databases, but not all of them. In the past I have had problems with...

I have two sites hosted on same server one is Dev and other is Live in cpanel i want to know there is any feature in cpanel to sync both databases

Hi, I need a script that search throught ALL MYSQL databases in WHM, inside all wp_users tables, if there is a user with is called "XXXXX" Is there anyway to do it using WHM CONSOLE or using WHM Root's PhpMyAdmin ? Thanks, Francisco

Hi, I need to find all the MySQL databases where there is a specific word How can I do it using WHM Console or WHM PHPMYADMIN? Thanks, Francisco

Currently installed mariadb 10.5 on server. But now some websites need postgresql. so how can i install multiple database software on cpanel server.

Hello, I recently copied a database in phpMyAdmin using the "Operations" interface. After copying, I intended to use whm's "manage databases" interface to adjust the permissions on the copied database as it was only to be use for development purposes. Unfortunately, the database does not show...

Hi, I'm trying to connect from my local system to all of the databases with HeidiSQL or dbForge the same as if I was to log into WHM and then click on phpMyAdmin. I've added my IP to the Additional MySQL® Access Hosts page and applied it to all cPanel accounts, but if I try and connect it says...

Hello everyone, Quite a few accounts on my server was compromised, the admin username are changed to Anonyous_fox_xxx. I managed to revert all of those back to the original version, but the hacks keep on coming back. (all WP sites) I think the hack is not ROOT compromised, because only Google...

Hi, Our server has a lot of WordPress installations installed across different cpanel accounts and I am looking for a way to search all of the databases to find certain emails/phrases. For example, search 1: - Search all databases in the table "wp_options" and/or "*_options" for the...

Hi, for a few days, probably due to a WHM update, I can't open the databases in phpMyAdmin (expand and collapse function does not work, i attach screen shot). How can I fix the problem? Thank's a lot for support! Alex

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, is there any way to tell which databases are active? I know I can look in each wordpress config php file but I was not sure there was a way to look at the WHM or Cpanel and know which ones are actively attached to a website. Thanks

Hi, I'im trying to install cpanel, but after of some minutes, the following messages appears every second in the console: (INFO) Waiting for (SQL Databases and dependent apps). I tried with a clean CentOS 7.3 clean installation and with a CentOS 7.8 clean installation too. I need help asap...

Hi, when I am accessing Cpanel > MySQL® Databases (See the image Imgur) I am getting the following error message: The MySQL server is currently offline. (See the Image Imgur) But everything works fine - I have multiple Wordpress installations on this server and they are connected to SQL...

Hello, I have 2 quick Questions for the next release of cPanel & WHM ver. 88 I've read that it will support Mysql 8 1st question : if we have already updated to MariaDB 10.3 is there a way to upgrade to Mysql 8 or not possible ? 2nd question : is there a huge speed difference between Mysql...

Somewhere in the cPanel file structure is a couple of my.cnf examples. I can't remember where. Any help appreciated.

Hi, I'm fighting with low free disk space on my server and one of the things that uses allmost 3G of space are sqlite files in /var/cpanel/bandwidth and one of the files is 2.6G. I have deactivated all the stats tracking services (awstat and similiar) but this files keep on growing. Since I...

Hey everyone, we just bought a new server and we'd like to install cPanel as well, but during installation, we got a problem which never meets us which is : [2019-09-30 12:40:06 +0000] [2234] ( INFO): Waiting for (SQL Databases and dependent apps). it's stoping just like that. - Removed - hope...

Hi Team, I initially amended this file /usr/local/cpanel/3rdparty/etc/freshclam.conf and added for example additional cdb / databases example: DatabaseCustomURL http://LinkRemoved/sanesecurity/foxhole_js.cdb DatabaseCustomURL http://LinkRemoved/sanesecurity/foxhole_js.ndb DatabaseCustomURL...

Hi I just took a server linux centos 7. In the Cpanel I can not find the file manager and the ability to create a new database. How to do ? Thanks