Viewing articles tagged 'mysql'

How to Download a MySQL Database Backup in cPanel The cPanel Backup interface can download individual database backups. Open cPanel → Files →... How to Restore a MySQL Database Backup in cPanel To restore a database partial backup through cPanel: Open Backup or Backup Wizard →... Diagnosing a Database “Access Denied” Error A MySQL or MariaDB “Access denied” error usually means the connection credentials or privileges... Diagnosing a Database “Too Many Connections” Error MySQL returns “Too many connections” when all ordinary client connection slots are in use. The... Diagnosing “MySQL Server Has Gone Away” “MySQL server has gone away” can occur when a connection is closed after a timeout, when a client... Diagnosing Database Packet Too Large Errors MySQL rejects a communication packet that exceeds the active max_allowed_packet limit and can... Diagnosing Symptoms of a Damaged Database Table Database-table damage can produce query errors, missing data, or application failures, but those... Understanding Databases, Database Users, and Privileges in cPanel MySQL and MariaDB applications normally use three related pieces of information: a database, a... How to Create a Database with cPanel Database Wizard Current cPanel documentation recommends Database Wizard for creating the first database and... How to Create and Manage Databases in Manage My Databases In current cPanel versions, the main MySQL/MariaDB management interface is named Manage My... How to Change a Database User Password Database-user passwords can be changed from Manage My Databases. Locate the database user.Choose... How to Check and Repair a Database in cPanel Manage My Databases includes tools to check a database for errors and attempt repairs.... How to Configure Remote Database Access in cPanel When enabled, Remote Database Access allows specified remote hosts to connect to MySQL or MariaDB... Understanding cPanel Database Connection Settings A web application generally needs a database name, database username, password, and database... Troubleshooting Database Connection Errors When an application reports that it cannot connect to its database, verify the connection in a...
« Back