| Bug #31007 | MySQL ODBC change remote server host IP | ||
|---|---|---|---|
| Submitted: | 14 Sep 2007 0:25 | Modified: | 1 Oct 2007 20:07 |
| Reporter: | Fernando Jimenez | ||
| Status: | Closed | ||
| Category: | Connector/ODBC | Severity: | S3 (Non-critical) |
| Version: | 3.51.20 | OS: | Microsoft Windows (XP) |
| Assigned to: | Target Version: | ||
[14 Sep 2007 14:30]
Miguel Solorzano
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 16: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 16:32]
Susanne Ebrecht
This is a duplicate of bug #16178
[14 Aug 22: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.
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...