Using phpMyAdmin to Manage Your Database

phpMyAdmin is a browser-based tool that lets you interact with MySQL databases without writing SQL from the command line. Through your CyclebreezeHost cPanel account, you can create tables, run queries, and move data in and out of your databases with a point-and-click interface.

Run queries, edit tables, and import or export databases via phpMyAdmin.

Accessing phpMyAdmin

  1. Log in to your cPanel account at clients.cyclebreezehost.com.
  2. Scroll to the Databases section and click phpMyAdmin.
  3. Your databases are listed in the left-hand panel. Click a database name to expand its tables.

If you have not yet created a database, go to MySQL Databases in cPanel first, create the database, create a user, and assign the user full privileges before returning to phpMyAdmin.

Browsing and Editing Data

  1. Select a database in the left panel, then click a table name.
  2. Click the Browse tab to view rows.
  3. Click the pencil icon next to any row to edit its values inline.
  4. Click Go to save changes.

To delete a row, check the checkbox beside it and click Delete at the bottom of the table.

Running SQL Queries

  1. Select your database in the left panel.
  2. Click the SQL tab at the top.
  3. Type or paste your query into the text area — for example:
    SELECT * FROM wp_users WHERE user_email = 'you@example.com';
    
  4. Click Go. Results appear in a table below.

Use the Format button to auto-indent long queries before running them.

Creating and Dropping Tables

  1. Select your database, then click the Structure tab.
  2. To add a table, scroll to the Create table form at the bottom, enter a name and column count, and click Go.
  3. Fill in column names, data types, lengths, and attributes, then click Save.
  4. To remove a table, check the box next to its name in the structure list and choose Drop from the With selected dropdown. Confirm the prompt — this action is irreversible.

Importing a Database

  1. Select the target database in the left panel.
  2. Click the Import tab.
  3. Click Choose File and select your .sql or .sql.gz file.
  4. Leave the format set to SQL unless you are importing CSV or another format.
  5. Click Go. A success message appears when the import finishes.

Large imports (above 50 MB) may time out through the browser. For oversized files, use the SSH terminal or split the file into smaller chunks before importing.

Exporting a Database

  1. Select the database you want to back up.
  2. Click the Export tab.
  3. Choose Quick for a standard SQL dump or Custom to select specific tables, add DROP TABLE statements, or change the output format.
  4. Click Go. Your browser downloads the .sql file immediately.

Schedule regular exports or use JetBackup in cPanel for automated, restorable snapshots.

Common Tips

TaskWhere to find it
Reset a WordPress admin passwordwp_users table → Edit row → set user_pass type to MD5
Find table prefixwp_options table → siteurl row
Check database sizeLeft panel — size shown below each database name
Repair a tableOperations tab → Table maintenance → Repair table

If you encounter a database connection error on your site, verify that the database username and password in your application's config file (e.g., wp-config.php) match what is set under MySQL Databases in cPanel. For further help, open a support ticket at clients.cyclebreezehost.com and the CyclebreezeHost support team is available 24/7.