MySQL Forums
Forum List  »  Connector/ODBC

Re: Every new machine blocks connection
Posted by: Vitor Vitor
Date: June 20, 2023 09:36AM

Thanks and sorry for the delay
I had to get another new machine to test this out

I tried telnet / mysql cmd line / odbc ( through windows, not from our app ) BEFORE opening our app.

Everything connected fine! Not even a single block ( even on olders machines ).



After, I openned our app. It does not prompt ODBC.
Our app uses ADO to connect

We use the string "DSN=DPCOMP;server=IP_ADDRESS;uid=root;pwd=password;OPTION=35;Database=mysql"

So we connect using DSN ( we configure with the library, before )
Public Declare Function SQLConfigDataSource Lib "ODBCCP32.DLL" (ByVal hwndParent As Long, ByVal fRequest As Long, ByVal lpszDriver As String, ByVal lpszAttributes As String) As Long

As I said, I even tried to configure DSN manually before, which worked before opening the app.


After this, it blocked everything.


I tried telnet / mysql cmd line / odbc ( through windows, not from our app ) AFTER opening our app, as you sugested

Telnet : OK

MySQL cmd line :[MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'10.91.2.63' (using password: YES)

ODBC : [MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'10.91.2.63' (using password: YES)



After this, again, I did the following:
- Edited my.ini, adding skip-grant-tables
- Restarted the MySQL service
- Connected to the server ( doesn't need password )
- Remade all the privileges
- Edited my.ini, removing skip-grant-tables
- Restarted the MySQL service

Everything is fine again. Old machines can connect. New machine, can connect without dropping everything.

Dunno what is the problem. Just the first time of new machines drops everything.


Our password has "!" and "#" chars. Dunno if this is the problem, but it's hard to change it and test.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.