MySQL Databases
Information about managing your databases at Hostinger
22 articlesDatabase Management
How to change a database password in Hostinger
Changing a MySQL database password via Hostinger dashboard at Hostinger
How to change permissions for a database user in Hostinger
Changing permissions for a database user in Hostinger dashboard
How to create a new MySQL Database in Hostinger
Creating MySQL databases through via Hostinger dashboard at Hostinger
How to delete a database in Hostinger
Deleting MySQL databases at Hostinger
How to find your MySQL database details in Hostinger
Checking your MySQL database details via Hostinger dashboard
How to manage MySQL databases in Hostinger
Managing MySQL databases via Hostinger dashboard
phpMyAdmin
How to access phpMyAdmin at Hostinger
Access phpMyAdmin at Hostinger from Databases Management, the phpMyAdmin page, WordPress Dashboard, or a direct link to manage your database.
How to delete all database tables in phpMyAdmin in Hostinger
Delete all database tables in phpMyAdmin in Hostinger: select the tables, choose Drop, and confirm to empty a database before an import.
What is the database information_schema on phpMyAdmin
Exploring the role and use of information_schema in database management
Importing and Exporting Databases
How to export a database over SSH in Hostinger
Export a database over SSH in Hostinger: gather your database details, connect via SSH, and run mysqldump to create an .sql backup file.
How to export a database with phpMyAdmin in Hostinger
Export a database with phpMyAdmin in Hostinger: open your database, click Export, and download an SQL file to back up or move your website.
How to import a database over SSH in Hostinger
Import a database over SSH in Hostinger for files over 256 MB: upload the file, connect via SSH, run the mariadb command, and update your config.
How to import a database with phpMyAdmin in Hostinger
Import a database with phpMyAdmin in Hostinger: upload an .sql file up to 256 MB and fix common errors like format, size, and permissions.
Database Troubleshooting
How to fix the ‘MySQL server has gone away’ error at Hostinger
Solving MySQL timeout errors
How to fix the ‘User already has more than max user connections’ error at Hostinger
What to do if you reach the user connection limit
How to fix the max_connections_per_hour MySQL error at Hostinger
Solving max_connections_per_hour error
How to fix the MySQL 1064 error at Hostinger
Fixing the "#1064 - You have an error in your SQL syntax" error in phpMyAdmin
What to do if the database size limit has been reached in Hostinger
Fixing the database size limit error