How to Use phpMyAdmin? Print

phpMyAdmin is a web-based tool that allows you to directly interact with your database using SQL queries or a graphical interface. It's essential for advanced troubleshooting or manual edits.

Accessing phpMyAdmin:

1. Log in to cPanel.

2. In the "Databases" section, click on "phpMyAdmin."

3. A new tab will open showing the phpMyAdmin interface.

Common Tasks in phpMyAdmin:

• Browsing Data:

  • On the left sidebar, click on the name of your database to expand it.

  • Click on any table (e.g., wp_options, wp_users) to see its contents on the right.

• Editing Records (e.g., Change a Password):

  1. Click on the relevant table (e.g., wp_users).

  2. Click the "Browse" tab to see the rows.

  3. Click the "Edit" (pencil) icon next to the record you want to change.

  4. Modify the value (for passwords, select MD5 from the Function dropdown before entering a new one).

  5. Click "Go."

• Running SQL Queries:

  • Click on your database name in the left sidebar.

  • Click the "SQL" tab at the top.

  • Enter your SQL command (e.g., SELECT * FROM wp_options WHERE option_name = 'siteurl';).

  • Click "Go."

• Exporting/Importing (Backup):

  • Click on your database name.

  • Click the "Export" tab to download a backup (usually "Quick" method as SQL).

  • Click the "Import" tab to upload and restore a backup.

Warning: Be careful when editing your database directly. Making incorrect changes can break your site. Always back up first.