Overview
The following provides solutions to a few common issues that can occur in a MySQL database.
SSH access
There is no SSH access to a Shared or Private MySQL server. All troubleshooting must be done in the DreamHost panel or within your software.
If you require SSH access, you must upgrade to a Dedicated Server or DreamCompute, where the database is hosted on the same machine.
Logging in
If you are not able to log in with the username, the issue may be the settings in your Allowable Hosts file.
Updating 'Allowable Hosts'
You can manage this setting on the MySQL Databases page. To the right of your database, click the username to view the settings page.
In the image above, replace xxx.xxx.xxx.xxx with your computer's IP address. You can find it on a site such as whatismyipaddress.com. The panel also displays your current IP address in this section.
Make sure that your current IP address is added to this field.
Server issues
Shared and VPS plans
Rebooting the server can often resolve common server issues. However, due to the nature of shared MySQL hosting, it's not possible to reboot your MySQL server. If you notice any server-related issues, please contact support for further assistance.
Dedicated plans
Rebooting is only possible if you are on a Dedicated Hosting plan. On a Dedicated Server, the MySQL server is hosted on the same machine allowing you full root access.
Errors importing a database with mysqlimport
DreamHost has implemented some newer features in MySQL 8, which may cause an error to occur when using the command-line program mysqlimport. For more details, see the MySQL overview page.