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
Access the control panel
Log in to control.intergrid.cat
Look for the link to phpMyAdmin
In the databases section of your hosting, you will find a direct link to phpMyAdmin.
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
Deleting tables or records from phpMyAdmin can cause errors on your website. Always make a backup before making important changes.
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