mysql --skip-secure-auth
-
wrote on 13 Dec 2015, 17:29 last edited by Gianmarco 7 Dec 2016, 18:23
Hello Everyone, i would like to know how i can send to a Remote(not localhost) Db this command
mysql --skip-secure-authdue to this error that i get when i connect :
Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) QMYSQL: Unable to connect"I tried to look around but i wasn't able to find anything.
Any idea?
Thanks -
Hi,
AFAIK, that option is not handled at all in Qt's MySQL driver so you would have to add it yourself to it. However, I would rather fix the origin of that error rather than dropping the security of a remote connection to a database.
-
Hi,
AFAIK, that option is not handled at all in Qt's MySQL driver so you would have to add it yourself to it. However, I would rather fix the origin of that error rather than dropping the security of a remote connection to a database.
wrote on 14 Dec 2015, 02:16 last edited by@SGaist Yeah, but i can not access mysql console. i'm trying to connect to a website DB that is owned by an hosting company. and they cant not help me.
I'm using libmysqlclient.so.18 that should be the last one for the Driver, so...if anyone got an idea would be cool.
Thanks -
wrote on 14 Dec 2015, 03:29 last edited by
FIXED following this
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
-
Way better !
By the way, no need to modify the thread title anymore, just use the "Topic Tool" button to mark the thread as solved :)
1/5