Please Help: Access to MySQL drama

shanda posted this at 16:17 — 23rd January 2003.

Joined: Jan 2002

I have everything set up just fine as far as I can tell. I've installed the ODBC driver to support the transfer of my files from ACCESS to my MySQL server.

I get to the ODBC Data Source Administrator, and set things up as below:

Host/Server Name : IP of my domain
Database Name: mydb
User: myname
Password: mypass
Port :
SQL command on connect:

Then I press okay, and get the error of:

Access denied for user: 'myname@myLocalMachineIP' to database mydb

I guess that what I'm not understanding is why it replaces the IP of the domain I'm trying to connect to, with my local IP. I am connected to the internet btw and don't see why this is happening.

Please help and thanx in advance

CPRhosting.com - CPR Hosting...Giving life to the web
Custom-made Hosting Plans starting at $2

Mark Hensler posted this at 17:57 — 23rd January 2003.

He has: 4,048 posts

Joined: Aug 2000

mySQL not only validates users based on their username and password, but also on the hostname of the machine they are connecting from. You'll have to check your `mysql.user` table and check to see what the `host` field is set to for the user you are trying to connect as.

If the value is "%", that is a wild card and you may connect from any host. If the value is "localhost", you may only connect from localhost. There may be more than one record for any given user/pass combination.

Mark Hensler
If there is no answer on Google, then there is no question.