phpMyAdmin: Manage MySQL on web hosting

Use phpMyAdmin on web hosting

phpMyAdmin is the standard web interface to administer your MySQL databases on theweb hosting Anthony IT Solutions: Table view, SQL queries, import/export and maintenance without command line.

Accessible from panel hosting, phpMyAdmin completes the creation of MySQL databases for WordPress, PrestaShop and PHP applications.

What you need

• Offer web hosting with MySQL
• Database and user created, create base
• Panel access Anthony IT Solutions
• Backup before structural change

Go to phpMyAdmin

1. Panel

   My Services → Manage → Databases → phpMyAdmin button.

2. Authentication

   MySQL user identifiers related to the database, not the panel password.

3. Basic selection

   Click the base in the left column; check the table prefix (wp_, ps_).

4. Timeout session

   Sessions expire; save the long SQL work.

Browse and view data

1. Structure

   Tab Structure: list tables, InnoDB engine, size.

2. Browse

   Browse tab to see the lines; limit the big results.

3. Search

   Global or table search to find a value (URL, e-mail).

4. SQL

   SQL tab for custom SELECT requests, always LIMIT on large tables.

Export a base (safeguard)

1. Export

   Export Tab → Fast or Customized method.

2. SQL Format

   Recommended for full restoration; check "Add DROP TABLE" if total replacement.

3. Compression

   gzip if > 50 MB, guide backups.

4. Selective tables

   Possible partial export for a table (e.g. wp_options only).

Import SQL dump

1. Upload limit

   phpMyAdmin often limits to 50-128 MB; compress or fragment the file.

2. Import Tab

   Select .sql or .sql.gz; float utf8mb4.

3. Timeout

   Big imports: increase max_execution_time PHP or import via command line (support).

4. Check

   Count the tables and test the site after import, migration.

Maintenance operations

• Never share MySQL IDs
• No direct modification wp_users without backup
• Use prepared queries in PHP code
• Watch base size, disk quota

1. Optimize

   Selection tables → Optimize table, recovers fragmented space.

2. Repair

   If table marked "in use" or corrupted after crash.

3. Empty table

   TRUNCATE via SQL, faster than DELETE for logs.

4. User and privileges

   Management from the panel, not phpMyAdmin, on shared hosting.

Troubleshooting

• #1045 Access denied, Bad user/password or privileges.
• Import fails size, Compress or contact support Anthony IT Solutions.
• White page phpMyAdmin, PHP Quota or expired session.
• Table doesn't exist, Bad reading base or prefix tables.

Frequently Asked Questions

Several bases?
One per user according to offer; select the correct one on the left.

Edit wp-config via phpMyAdmin ?
No, edit the file via SFTP.

Auto export?
Plan via cron or panel backups.

Recommended charset ?
utf8mb4_unicode_ci for WordPress and emojis.

Related guides

• Create MySQL database
• Sauvages
• Migration
• Cron tasks

See also our web hosting offer and all the procedures on wiki web hosting.