How to manage MySQL/MariaDB

Learn to use phpMyAdmin to administer your MySQL/MariaDB databases.

What is phpMyAdmin?

phpMyAdmin is a web tool that allows you to manage MySQL/MariaDB databases in a visual and simple way, without needing to know complex SQL commands.

  • Explore and edit tables and data
  • Import and export databases
  • Execute SQL queries
  • Manage users and permissions

Access phpMyAdmin

1

Access the control panel

Log in to control.intergrid.cat

2

Look for the link to phpMyAdmin

In the databases section of your hosting, you will find a direct link to phpMyAdmin.

3

Login

Enter the user and password of the database you want to manage.

Common operations

Export a database

Click on the 'Export' tab, select the format (usually SQL) and click 'Continue' to download the backup.

Import a database

Go to the 'Import' tab, select the SQL file and click 'Continue'. Make sure the file doesn't exceed the size limit.

Search and edit records

Click on a table to view its records. You can edit, delete or add new records from here.

Execute SQL queries

In the 'SQL' tab you can execute custom queries to manipulate data in an advanced way.

Important tips

Caution with operations

Deleting tables or records from phpMyAdmin can cause errors on your website. Always make a backup before making important changes.

Export before modifying

Before making important changes to the database, export it to have a recent backup.

Need help?

If you have questions about how to use phpMyAdmin, contact our support team.

Create support ticket