How to use phpMyAdmin

phpMyAdmin

Overview#

phpMyAdmin is a web-based database management tool that allows you to view, manage, and edit your MySQL databases through an easy-to-use interface.

You can use phpMyAdmin to:

• View database tables
• Browse and edit data
• Import and export databases
• Run SQL queries
• Manage database structure

Access phpMyAdmin#

To access phpMyAdmin:

1. Log in to your hosting control panel.
2. Select your hosting package.
3. Open phpMyAdmin.
4. Locate the MySQL server that contains your database.
5. Click Sign In.

You will be automatically logged in to phpMyAdmin.

MySQL Host Selection#

Some hosting packages may store databases across multiple MySQL servers for improved performance.

The MySQL Host Selection page shows:

• The server hostname
• Databases stored on that server
• A Sign In option

Select the appropriate server to access your database.

Understanding the phpMyAdmin Dashboard#

Once logged in, you’ll see the phpMyAdmin dashboard.

Database List#

Located on the left-hand side, this displays all databases available on the selected server.

SQL#

The SQL tab allows you to run database queries directly.

Import#

Use the Import tab to upload and restore database backups.

Supported formats typically include SQL files.

Export#

Use the Export tab to download a backup of your database.

Common Tasks#

phpMyAdmin can be used to:

• Import a database backup
• Export a database backup
• View website data
• Edit database records
• Create or remove tables
• Run SQL commands

Important Notes#

• Changes made in phpMyAdmin take effect immediately.
• Always create a backup before making major database changes.
• Only edit database records if you understand their purpose.