Hello!
Does anyone know how to connect a vb.net application to a mysql database server using openssl?? I have mysql under Mandrake 10.1 with openssl.
I connect this way:
_____________________________
NOTE: DRIVER_ODBC is = "{MySQL ODBC 3.51 Driver}"
con = New ADODB.Connection
sentencia = "DRIVER=" & DRIVER_ODBC _
& ";SERVER=" & direccion _
& ";UID=" & usuario _
& ";PWD=" & contrasenya _
& ";DATABASE=" & nombre_bd
con.Open(sentencia)
_____________________________
Until now, what i tried is to give permissions to the users
GRANT ALL ON DB.* to
[email protected] IDENTIFIED BY 'hello';
with that works perfectly,
but when i do
GRANT ALL ON DB.* to
[email protected] IDENTIFIED BY 'hello' REQUIRE SSL;
it doesn't work.
Please, does anyone know how to do it???
And please, if you answer, could you include "easy-to-understand" sample code? I know it's not nice to say that, but many times you receive just stupid answers that don't tell nothing.
Ok!! Thanks ,
Roman.