mysql hosts question

[vocoder]

i need to add a user to my mysql installation....however, i use a web provider , so i'm not in control of mysql. lets say my default username is dbuser.

i am trying to run stuff locally on my computer and have it connect to the remote mysql server. However, it always fails because it says it doesn't recognize the user dbuser@mylocalmachine's.ip

so i assume this means i need to add a user and a host value to the mysql users table in mysql.......however my host has said they can add a user for me, but they won't modify the host value.

so my question is, is there anyway around this? would simply p utting "dbuser@mylocalmachine's.ip" in the user file work?

does this make sense?

[jburfield]

This is controlled by the user access inside of MySQL...if they have you set up as 'username'@'localhost' only then you will only be able to connect to the databse from the machine it is running on.

There is no way around it.

This is a good thing. It keep people from attempting to connect to the databases running on their server from outside of their network.

-- Jason