database

  1. I

    Restoring backup leaves database

    Hi Regarding to WHM Backup Restoration, there is something strange when I restore a backup for any account. If there is an old backup includes (some files in File Manager, emails and there is no any databases) Today, I created a new database and changed some files & emails. When I try to...
  2. M

    Resellers have no access to MySQL / phpMyAdmin

    Hello guys! All right with you? I have a problem with my whm that I have hosted on Google Cloud. I am unable to enable user access on mysql. Only from WHM and with root user I can access phpMyAdmin. When I migrated from the old server to this WHM that I host on Google Cloud, I used the...
  3. B

    Disable strict mode cPanel?

    Hi, I have an error and I cannot install a plugin and I get this error I know that it is not possible because of the mysql and I want to deactivate the mysql this is the error that skips me SQL Error: 1101 - BLOB, TEXT, GEOMETRY or JSON column 'buddylist' can't have a default value Query...
  4. I

    How to upgrade PostgreSql 9.2 to PostgreSql 9.6

    Just upgraded from PostgreSQL 9.6 to 10.3 on CloudLinux 6.9 but cPanel seems to only partially work with it. In cPanel, all of the PostgreSQL links have gone. But in WHM, its still visible such as the Configure PostgreSQL page and its listed in the Service Manager. However, if I run Install...
  5. A

    Create database using php code?

    I try to create Db using sql it's showing "Access Denied user" Here my code . $servername = "192.168.0.3"; $username = "root"; $password = "[Moderator Note: Removed]"; // Create connection $conn = new mysqli($servername, $username, $password); // Check connection if...
  6. I

    MySQL CPU usage 100%

    Hi I'm configuring a CentOS 7 VPS with 4 vCore and 24gb of RAM, I installed cPanel and I'm using it to host 2 Wordpress sites. There are 2 small dbs, totally about 400MB. The sites in production will have about 10k visits monthly, now the visits are low. Mysqld uses high cpu, about 80-120%...
  7. M

    PHPMyAdmin view all databases on server

    Hi this might be random and at the minute not causing no issues at all but i have noticed the databases on my servers are split into sections. I think in my theory I'm correct but still not sure. from what i can see the databases are in groups if there are more than 1 database per user...
  8. W

    MySQL/MariaDB upgrade error

    I tried to upgrade MySQL 5.6 to MariaDB 10.3 last week within the cpanel upgrade tool withtout succes so I made it in terminal. MariaDB upgrade was succesful but now I stuck with broken dependencies (I guess) blocking other uprade. Cpanel seems to still see MySQL 5.6 as the default db server...
  9. N

    SOLVED Enable phpMyAdmin relation feature?

    Hello how can i enable table relation on phpmyadmin? I got error relational features are disabled Thanks
  10. K

    SOLVED [CPANEL-28306] webmail and/or phpmyAdmin stuck at loading screen

    I have an issue similar to this but I couldn't reply to that old topic anymore. CSF/LFD reports something like this: lfd on xxx: Excessive resource usage: xxx Time: Sat Jul 6 16:02:00 2019 Account: xxx Resource: Process Time Exceeded: 84921 > 1800 (seconds) Executable...
  11. N

    cPanel not restarting postgres service

    Hello, After upgrading Postgres from 9.2 to 9.4 and starting the new service 9.4 and confirming that the running version is 9.4, the Restarting PostgresSQL Server tool via WHM no longer works. I think that because there's no symbolic between the service bin file and the new upgraded version...
  12. M

    Enable outbound SQL?

    I have a site on a WHM/CentOS dedicated server. This 144.x.x.x server has a client who has a remote database on a different server (37.x.x.x) and he needs to connect his script from the local server over to that 37.x server using a remote MySQL connection. Up until now all he gets when we...
  13. B

    cPanel update mistakenly assuming to be running MySQL 5.5

    Upgrade to Latest VersionHy, everyone! One of our servers is now having cPanel upgrades blocked because it assumes to be running on MySQL 5.5 for whatever reason: [2019-07-01 21:18:16 -0300] W NOTE: A system upgrade was not possible due to the following blockers: [2019-07-01 21:18:16 -0300] W...
  14. G

    Operation not allowed when innodb_forced_recovery > 0

    Hello Everyone Few days back my dedicated server has passed through a severe hard drive crash and my service provider unable to recover the data. They suggested me to go with a brand new server and create vps nodes there and migrate data one by one to the new vps nodes. (As bulk migration stops...
  15. W

    Can't connect to MySQL database PHP7

    Good afternoon, I am trying to connect my PHP project that is hosted on my CPanel website to the MySQL database that i have setup on CPanel's PHPMyAdmin however I can't. I think it is because i am using the incorrect username and password to access the CPanel database (The project was initially...
  16. R

    Notifications MySQL not running, while actually running

    I am receiving email notifications after I rebooted my VPS about the MySQL not running. In WHM I can see the MySQL service marked as down. However, MySQL seems to running fine. When I run the command service mysql status I get SUCCESS! MariaDB running (5139) When I run /scripts/restartsrv_mysql...
  17. J

    SOLVED Uninstall PhpMyAdmin?

    Doesn't seem like this question gets asked alot, but is there a way to completely remove CPANEL from WHM? Is this, from 2011, still valid? how to uninstall phpmyadmin included with cpanel installation Delete (though i would just chmod it away) /usr/local/cpanel/base/3rdparty/phpMyAdmin ...
  18. G

    phpMyAdmin forgets previous SELECT

    I'm having a new issue with PMA 4.8.3 (PHP 7.2.7), and I'm hoping someone can suggest a fix. I have a rather large table (2.4G, about 10 million rows), and I regularly run queries on it to find specific data and then copy a row. I run something like: SELECT * FROM table WHERE colA = 'foo' AND...
  19. S

    Upgrading MySQL Concerns

    Hi I am very new to cpanel and MySQL in general. Currently trying to upgrade MySQL version but it says that there will catastrophic data loss if i proceed. I'm wondering if i can create a new MySQLServer upgrade that to the latest version and then import the data from the old server?
  20. S

    The system failed to determine the mysqld version

    hi guys i installing cpanel on centos 7.1 64 bit after creating account i will giving error my error is : Account Creation Status: failed Cpanel::Exception/(XID fq4zz2) The system failed to determine the “mysqld” version. at /usr/local/cpanel/Cpanel/MysqlUtils/Version.pm line 194...