Databases
MySQL/MariaDB databases, users, phpMyAdmin, imports and exports.
12 articles
Creating and managing
- What is MySQL (and MariaDB)?
Databases explained simply: what MySQL and MariaDB store, how tables, users and privileges work, and how a website uses them.
- MySQL vs MariaDB: what’s the difference?
How MariaDB relates to MySQL, whether your application cares which one it gets, and the few places they differ.
- How to create a MySQL database in DirectAdmin
Create a MySQL/MariaDB database and user in DirectAdmin, understand the account prefix, and note the details your application needs.
- Managing database users and privileges
Add users to a database, choose privileges, use separate users per application, and remove access you no longer need.
- How to access and use phpMyAdmin
Open phpMyAdmin from DirectAdmin, find your way around, browse and edit data safely, and run SQL queries.
- How to change a database user’s password
Reset a MySQL user’s password in DirectAdmin and update your application’s configuration so the site doesn’t go down.
- Connecting a PHP application to your database
The connection details for Traxio databases and working examples with PDO and mysqli, including safe queries and keeping credentials private.
- Keeping your databases secure
Protect your website’s databases: separate users, strong passwords, prepared statements, safe credential storage and backups.
Import, export and repair
- How to export a database (backup with phpMyAdmin)
Download a copy of a MySQL database with phpMyAdmin’s Export tab, choose the right options, and check the backup isn’t empty.
- How to import a database with phpMyAdmin
Restore or migrate a database by importing an SQL file with phpMyAdmin, and fix the errors imports commonly hit.
- Importing a database that’s too large for phpMyAdmin
Options for importing big SQL files: compression, splitting the file, importing table by table, and restoring through a DirectAdmin backup.
- How to repair and optimise database tables
Use phpMyAdmin to check, repair and optimise MySQL tables, and understand when corruption is really the problem.