How to access and use PHPmyAdmin for managing SQL databases Print

phpMyAdmin is a web tool for working with your MySQL databases. You can use it to back up (export) a database, restore (import) one, or make direct changes.

Opening phpMyAdmin

In cPanel, go to Databases › phpMyAdmin. It opens in a new tab, and you're logged in automatically. Your databases are listed on the left.

Export (back up) a database

1. Click the database name on the left.
2. Click the Export tab.
3. Leave the method as Quick and the format as SQL.
4. Click Export (or Go). A .sql file downloads to your computer.

Import (restore) a database

1. Create an empty database first if needed (see How to create a MySQL database and user), and select it on the left.
2. Click the Import tab.
3. Click Choose File and select your .sql file. Compressed .sql.gz and .zip files also work.
4. Click Import (or Go).

Running an SQL query

Select the database, click the SQL tab, type or paste your query and click Go.

Example: reset a WordPress admin password

1. Select your WordPress database and open the wp_users table. The prefix may differ, e.g. wpxy_users.
2. Click Edit next to your user.
3. In the user_pass row, choose MD5 from the Function menu and type a new password in the Value box.
4. Click Go. You can now log in with the new password. WordPress automatically upgrades it to stronger encryption.

Example: fix the site address after a move

In the SQL tab, run (changing the prefix and address as needed):

UPDATE wp_options
   SET option_value = 'https://yourdomain.co.uk'
 WHERE option_name IN ('siteurl', 'home');

Still stuck? Contact Raleway support and our team will be happy to help.