Databases
MySQL and PostgreSQL databases and users, the database tool, remote access, importing and exporting.
- How to create a MySQL database and database user Customers
Create a MySQL (MariaDB) database and a database user in the control panel, add the user to the database, and get the details your website needs.
- How to add a user to a MySQL database (privileges) Customers
Give a database user access to a MySQL database with Grant all privileges, remove its access again, and understand which privileges the user gets.
- How to open phpMyAdmin to manage your MySQL databases Customers
Open phpMyAdmin from the control panel with one click, without a database password, on its own port 2097, and what you can and cannot do there.
- How to import a MySQL database (.sql file) and size limits Customers
Import a .sql or compressed .sql.gz backup into a MySQL database with phpMyAdmin (up to 512 MB) or the mysql command over SSH for larger files.
- How to export a MySQL database (download a .sql backup) Customers
Download a copy of a MySQL database as a .sql file with phpMyAdmin's Export tab or mysqldump over SSH, for backups or moving to another server.
- How to change a MySQL or PostgreSQL database user password Customers
Set a new password for a database user in MySQL Databases or PostgreSQL Databases, then update wp-config.php or your app's settings so the site keeps working.
- MySQL connection details: host, port, socket and examples Customers
The database host (localhost), port 3306, socket path, name and user format to connect WordPress, PHP, Laravel, Node.js or Python to MySQL, with examples.
- How to allow remote MySQL access from your computer or server Customers
Let a desktop tool or an app on another server connect to your MySQL databases on port 3306 by allowing its IP address or range in Remote MySQL.
- How to check and repair a crashed MySQL table Customers
Fix "Table is marked as crashed and should be repaired" with Check & repair in MySQL Databases, read the result, and what to do when a table cannot be repaired.
- How to create a PostgreSQL database and user Customers
Create a PostgreSQL database and user in the control panel, add the user to the database, and connect your app with host localhost and port 5432.
- How to browse, query and export a PostgreSQL database Customers
Use the built-in PostgreSQL tool to browse tables, run SQL queries (15-second limit, 500 rows) and export the database as a .sql file to your home folder.
- Error establishing a database connection or access denied Customers
Fix "Error establishing a database connection" and MySQL "Access denied for user" errors: wrong name prefix, password, privileges, host or remote access.
- Database error "Too many connections": causes and fixes Customers
Why MySQL or PostgreSQL report "Too many connections" or "too many connections for role", and how to fix it with caching, connection pools and fewer cron jobs.