MySQL - Access Denied On User

[jwong78]

I'm running Win 2000 Pro and using MySQL 4 and I can't connect to a databsae when I'm connected to the internet.

If I'm not connected to the internet then everything works fine. The problem arises once logged on to the net.

I get this error;

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]Access denied for user: '@00.000.000.00' to database 'db_name'

How can I connect to this database whislt on the internet. I connect to the internet through an ISP, given a random client IP each time connected.

Thanks for your help.

 

[tarn]

Have you read:

http://www.mysql.com/products/myodbc/manual_toc.html

Sounds like your not looking at localhost (127.0.0.1) when your connected to WAN, may be a simple case of adding:

localhost <tab> 127.0.0.1

into your dB server's hosts file? but read manual (as above first)

Good Luck
Laurie.

 

[QatQat]

More than likely you installed your Windoz box with the fully qualified domain name and then set the DNS to your ISP DNS server. When you connect, the box becomes

yourPC.yourlocaldomain.yourISPdomain.com changing its host name.


Try remove the DNS settings if they are there.


Bye


Qatqat




The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)