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
Look for the link to phpMyAdmin
In the databases section of your hosting, you will find a direct link to phpMyAdmin.
Sign in
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
Before making important changes to the database, export it to have a recent backup.