Bug #31007 MySQL ODBC change remote server host IP
Submitted: 13 Sep 2007 22:25 Modified: 1 Oct 2007 18:07
Reporter: Fernando Jimenez Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.20 OS:Windows (XP)
Assigned to: CPU Architecture:Any

[13 Sep 2007 22:25] Fernando Jimenez
Description:
Hello,

I had intalled the new MySQL ODBC and create an ODBC Connection, but when I test the connection show me a error: "Request returned with SQL_ERROR", in the diagnostic show me: [MySQL][ODBC 3.51 Driver]Access denied for user '*************'@'201.87.12.58' (using password: YES), the problem is in the IP number, this IP number is diferent I insert in "Server" field, I insert IP number: 67.15.36.6 no IP: 201.87.12.58 this IP is of my cable ADSL provider....

Obs.: My remote host server accept remote connections...
     

Thanks,

Fernando Jimenez
Brazil
domsgo@gmail.com

How to repeat:
The same problem when connect with my others servers... bring the IP of my ADSL provider, 201.87.12.58, and make an autentication in my remote server with 'my_password'@'201.87.12.58' when the IP insert in "Server" field is other...
[14 Sep 2007 12:30] MySQL Verification Team
Thank you for the bug report. Are you able to connect with the server
using the mysql.exe client tool using the same connect parameters?. Thanks
in advance.
[14 Sep 2007 14:14] Fernando Jimenez
Hi Miguel Solorzano

Ok. Already it is working fine, I'm created a new user with shortest username and a different password, without special characters, as "*", and functioned immediately.

In previous password I had used, in the composition, the character "*" also a longer username, later that I changed both, started to work well. I believe that it has been this. When I will have free time, I go to make some tests with username and password variants to try to discover this. 

Thank for your effort in aid.

Best regards

Fernando Jimenez,
Brazil
[1 Oct 2007 14:32] Susanne Ebrecht
This is a duplicate of bug #16178
[14 Aug 2009 20:05] Neal P.
Check out your machine.config file. 
It contains settings that apply to an entire computer. This file is located in the %runtime install path%\Config directory. 
Machine.config contains configuration settings for machine-wide assembly binding, built-in remoting channels, and ASP.NET.