Databases

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

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.