How to Manage Databases with phpMyAdmin

phpMyAdmin is a powerful, web-based tool for managing your MySQL and MariaDB databases. It provides a visual interface for browsing tables, running SQL queries, editing records, and performing database administration tasks - all without needing to use the command line. dotCanada includes phpMyAdmin with every cPanel hosting account.

Accessing phpMyAdmin

1. Log in to your cPanel account.
2. In the Databases section, click phpMyAdmin.
3. phpMyAdmin will open in a new tab, and you will be automatically logged in using your cPanel credentials.

Navigating phpMyAdmin

• Left Panel: Lists all databases on your account. Click a database name to expand it and see its tables.
• Main Panel: Displays the currently selected database or table, along with action tabs.

Common Tasks in phpMyAdmin

• Browse a Table: Click on a table name in the left panel, then click the Browse tab to view its records.
• Search Records: Use the Search tab to query specific records within a table.
• Edit a Record: Click the pencil icon next to any row to edit its values.
• Delete a Record: Click the red delete icon next to a row. Be careful - this cannot be undone.
• Run SQL Queries: Click the SQL tab on any database or table to run custom SQL commands directly.
• Create a Table: Select your database, then use the Structure tab or the create table form at the bottom of the left panel.

Exporting and Importing

phpMyAdmin also allows you to export your database as a .sql file for backup purposes, or import a .sql file to restore or migrate data. See the related article on importing a database for step-by-step instructions.

If you need help with phpMyAdmin or have questions about your database, contact our support team and we will be happy to assist.