I want to update a mysql database on dreamhost from a mysql client on my local server. Before I signed up the sales folks said all hosting plans allowed this.
My problem is I can’t seem to GRANT privleges to a user from an outside host (ie: email@example.com) as I don’t have access to the mysql user table. How do I do this?
The panel only allows 16 characters when you add a user, so you can’t do it from there either.
Log into the Panel - Goodies> Mysql > Modify the user on the database you want to access. You’ll put in your IP address here so that the server knows to allow your connection.
I would try that, but the panel hasn’t been working all morning (Friday May 27th, 2005).