Knowledgebase

  1. Cheap cPanel license , CloudLinux license , LiteSpeed license, Imunify360 license , etc
  2. Knowledgebase
  3. cPanel/WHM Troubleshoots
  4. Databases

  Categories

1
All In One Licenses Instructions
283
cPanel/WHM Troubleshoots
 2
KNOWN ISSUES
 3
Legal

  Categories

  Tag Cloud

cPanel /scripts/ - Powerful commands from cPanel Server is inaccessible once rebooted after installing the cPanel

  Support

  My Support Tickets   News   Knowledgebase   Downloads   Network Status   Open Ticket

Articles

500 ISE error when uploading database in phpMyAdmin compressed in zip format Symptoms When importing a sql dump compressed in the zip format into phpMyAdmin, you find... After upgrading to version 8.4.5 MySQL will throw database connection error in all sites Symptoms Sites are throwing a database error after an upgrade.   Description The... Can't add db user to db due to ER_PASSWORD_NO_MATCH error Symptoms Adding a database user to a database results in the following error, or similar: The... Cannot add user to database: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table) Symptoms Users cannot be added to databases, and privileges cannot be added to database... Database creation error :: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Symptoms The following database error happens when attempting to create or restore a database:... Error when you attempt to map a cPanel username to itself. Symptoms dbmap tool UI and CLI - fail with error when you attempt to map a cPanel username... Failed to run /usr/bin/yum-config-manager on the repository named Mysql55-community Symptoms Attempting to upgrade from MySQL 8.0 to 8.4 results in "Failed to run... How to import a MariaDB 10.x database on a MySQL 8 server or vice versa Introduction MariaDB 10.x and MySQL 8.x databases have structural differences that prevent... How to repair a crashed MyISAM database table from the command line Introduction An error similar to the following will be encountered when running a backup.... How to repair a crashed database table in cPanel Introduction An error similar to the following will be encountered when running a backup.... How to restart MySQL from the command line Introduction Sometimes, we need to restart MySQL for a configuration change or regular... How to restore a database from a daily backup Introduction The following procedure provides the steps to restore a database from a daily... How to set MAX_USER_CONNECTIONS for a MySQL user Introduction Some administrators may need to set a different MAX_USER_CONNECTIONS value... How to upload additional themes for PHPMyAdmin Introduction In order to provide a better experience for your users, you may want to upload a... Invalid default value for 'column_name' Question Why does my database fail to import with a similar error? ERROR 1067 (42000) at... MariaDB [ERROR] Couldn't load plugins from 'auth_socket.so' Symptoms New installations of MariaDB 10.11 are unable to load the auth_socket.so plugin,... MariaDB upgrade fails with "the data directory cannot reside in /home" Symptoms When performing a MySQL/MariaDB upgrade, an error similar to the following is... MariaDB upgrade from MySQL 5.7 fails with "NO_AUTO_CREATE_USER" error. Symptoms When trying to upgrade to MariaDB from MySQL 5.7 the following error is presented... Should I use skip-name-resolve in my.cnf? Symptoms When attempting certain database administration tasks through the cPanel... This system will not add the database user to the database because this user does not have a password Symptoms When attempting to add a database user to a database in cPanel, you are presented... UPCP warning in Ubuntu servers because of a non-responsive MariaDB repository/mirror. Symptoms The cPanel "upcp" script is reporting issues with the updates, we can see the... Unable to view a database under the “Manage My Databases”: The cPanel user “$username” does not exist in the database map Symptoms When accessing the "Manage my Databases" menu in cPanel, databases or users are... Upgrade to MariaDB 11.4 failed to find binary Symptoms Upgrading to MariaDB 11.4 failed and returns the following error. Note: The... Upgrading to 120 on CloudLinux server with CCS removes PostgreSQL Symptoms When upgrading cPanel to version 120 on a CloudLinux server with CCS installed,... What is a MySQL/Database Profile in WHM? Question What is a MySQL/Database Profile in WHM?   Answer A MySQL Profile (or Database... Yum update failed on CloudLinux with mysql conflicts Symptoms When updating system packages, you encounter conflicts similar to the following. file... cPanel password resets made in WHM do not update cPanel users database grants file. Symptoms Upon resetting a cPanel users password, you find that the users database grants... mysqli_sql_exception: Access denied for user Symptoms When logged into cPanel and trying to access phpMyAdmin, you are presented with... phpMyAdmin does not open from the cPanel interface Introduction When accessing PHPMyAdmin from cPanel, the interface never loads.   Procedure... phpMyAdmin fails to load: 'mysqli_sql_exception: Permission denied' Symptoms When accessing phpMyAdmin, the interface fails to load and provides the following...
Back

  Tag Cloud

cPanel /scripts/ - Powerful commands from cPanel Server is inaccessible once rebooted after installing the cPanel

  Support

  My Support Tickets   News   Knowledgebase   Downloads   Network Status   Open Ticket