General

• MySQL overview
• phpMyAdmin overview
• Finding your database login credentials

Backing Up / Importing / Migrating / Restoring

• Database backup overview
• How do I migrate my database to DreamHost?
• Restore a database in the panel
• Renaming your database in the DreamHost panel
• phpMyAdmin — How to backup or export a database or table
• phpMyAdmin — How to import a database or table

See all 8 articles

Connecting to MySQL Databases

• Access a database before pointing DNS to DreamHost
• Connect to a database via SSH
• Connecting to a database using MySQL Workbench
• Using SQLyog to connect to your database

Managing Databases

• Creating a MySQL database
• Adding and deleting a database user
• Dropping or deleting a database
• Managing existing MySQL databases
• Managing MySQL users, allowable hosts, and privileges
• MySQL limitations due to shared hosting

See all 7 articles

MySQL VPS (private server)

• MySQL VPS overview
• Add or delete a MySQL VPS

Troubleshooting / Optimization

• Using reserved words in MySQL 8
• Error establishing a database connection
• Troubleshooting your MySQL database
• Optimize a database
• Troubleshooting database import errors
• Move databases on to a single server

See all 7 articles

Alternative databases

• SQLite
• Installing a custom version of SQLite3
• PostgreSQL