mysql --skip-secure-auth
-
Hello Everyone, i would like to know how i can send to a Remote(not localhost) Db this command
mysql --skip-secure-auth
due 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.
-
@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 -
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 :)