Overview
This article provides solutions to common MySQL database issues on DreamHost — logging in, server problems, and errors when importing a database with mysqlimport.
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.
Why can't I log in?
If you are not able to log in with the username, the issue may be the settings in your Allowable Hosts file.
How do I update '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.
How do I resolve server issues?
Web Hosting and Managed 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.
Why do I get 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.