Troubleshooting your MySQL database

If you find yourself in a situation that requires changes to your site, and your developer isn't available to help, DreamHost's skilled support team may be able to assist you for a small fee. You can find more information about supported services and associated costs in the DreamHost Professional Services article.

Overview

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.

Problems logging in

Updating 'Allowable hosts'

Also, make sure that your current IP address is added to the database's allowable hosts. You can manage this setting on the MySQL Databases page.

To the right of your database, click the username. On the next page you can see the 'Allowable hosts' field.

allowable hosts.png

In the image above, you would 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.

Reboot the server

Due to the nature of shared MySQL hosting, it's not possible to reboot your MySQL server. The only way this would be possible is if you were on a Dedicated Hosting plan. On a Dedicated Server, the MySQL server is hosted on the same machine allowing you full root access.

Error messages

"Loading local data is disabled; this must be enabled on both the client and server sides"

This error can occur when using the LOAD DATA LOCAL INFILE statement to load data into a MySQL 8 database. A change to the default settings introduced in MySQL 8 no longer allows local data to be loaded, for security purposes.

It is possible to load data using an alternate method. See the MySQL Overview page for more details.

See also

Did this article answer your questions?

Article last updated PST.

Still not finding what you're looking for?