Connecting to mysql from offsite client

software development

#1

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: mysqluser@222.222.222.222) 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.

-Rick


#2

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.

-Matttail


#3

I would try that, but the panel hasn’t been working all morning (Friday May 27th, 2005).

-rick