Databases

Creating, editing, and deleting databases and database users in cPanel and DirectAdmin.

Why Your Website Can't Connect to Its Database (and How to Fix It)

If your website shows a database connection error instead of your homepage, it's almost always a mismatched database name, username, password, or host. Here's how to track down and fix the problem in both cPanel and DirectAdmin.

How to Connect to Your MySQL Database Using MySQL Workbench or HeidiSQL

Once remote MySQL access is enabled on your hosting account, you can connect to your database directly from a desktop tool like MySQL Workbench or HeidiSQL using your hostname, port, and database credentials.

How to Give a Database User Read-Only Access to a MySQL Database

Learn how to limit a MySQL database user to read-only (SELECT) access in cPanel or DirectAdmin, so a developer, accountant, or reporting tool can view your data without being able to change or delete it.

How to Access phpMyAdmin in cPanel and DirectAdmin

phpMyAdmin is the tool you use to manage your MySQL databases from your browser. Here is how to open it from both cPanel and DirectAdmin.

How to Import a Large MySQL Database When It's Too Big for phpMyAdmin

phpMyAdmin has an upload size limit set by your hosting's PHP configuration, so large .sql files often fail to import. Here are four practical ways to get a large database imported successfully.

How to Duplicate a MySQL Database in cPanel and DirectAdmin

Learn how to make a full copy of a MySQL database before testing risky changes, using phpMyAdmin's export and import tools. The process is the same whether your account runs cPanel or DirectAdmin.

How to Fix Garbled Text or Question Marks on Your Website Caused by Database Encoding Issues

If your website shows question marks, boxes, or broken symbols instead of proper text, the cause is usually a mismatch between your database's character encoding and the encoding your website expects. Here's how to check and fix it.

How to Edit Table Data Directly in a MySQL Database Using phpMyAdmin

Learn how to use phpMyAdmin's Browse and Edit tools to change a single value in a MySQL database table without writing SQL, plus how to run a manual UPDATE query for more precise edits.

How to Search and Replace Text in a MySQL Database Using phpMyAdmin

A step-by-step guide to finding and replacing text such as old URLs in a MySQL database through phpMyAdmin, including a safe approach for WordPress sites with serialized data.

How to Fix "Access Denied" Errors When Logging into phpMyAdmin

An access denied error in phpMyAdmin almost always means the database username or password you entered doesn't match what your control panel has on record. Here's how to find the correct credentials and fix the mismatch.

Understanding MySQL Database Size Limits and How to Reduce Usage

Your hosting plan's disk space includes your MySQL databases, and a database that keeps growing can eat into that quota. Here's how to check how big your databases are and bring the size back down.

How to Rename a MySQL Database

MySQL doesn't have a built-in rename option, but you can effectively rename a database using phpMyAdmin's Operations tab, then reconnect your database user in cPanel or DirectAdmin.

How to Fix a "Too Many Connections" Database Error on Your Website

Learn what causes a "Too many connections" database error on your website and the practical steps to identify the cause and fix it in cPanel or DirectAdmin.

How to Optimize and Repair a MySQL Database Using phpMyAdmin

Learn how to fix a slow or corrupted MySQL database by optimizing and repairing its tables in phpMyAdmin, using the same steps in cPanel and DirectAdmin.

How to Enable Remote MySQL Access to Your Database

Learn how to allow an external server or application to connect to your ZIPROF-hosted MySQL database by authorizing its IP address in cPanel's Remote MySQL tool or DirectAdmin's access hosts.

How to Change or Reset a MySQL Database User's Password

Learn how to reset a MySQL database user's password in cPanel or DirectAdmin, and how to update your site's configuration so it keeps working after the change.

How to Import and Export a MySQL Database Using phpMyAdmin

This guide shows you how to export a MySQL database to a file and import it back in using phpMyAdmin, covering both cPanel and DirectAdmin control panels.

How to Create a MySQL Database and Database User

Create a new MySQL database and a matching database user for a website or application, in cPanel or DirectAdmin.

How to Grant a Database User Access to a Database

Give an existing database user access to another database, useful when several applications need to share a login.

How to Delete a Database or Database User

Steps to permanently delete a MySQL database or database user in cPanel or DirectAdmin, and what to back up first.