Re: Every new machine blocks connection
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.