Contents
What is the error 2049 in MySQL client?
If i try to connect by mysql client: ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled) ERROR 1275 (HY000): Server is running in –secure-auth mode, but ‘root’@’localhost’ has a password in the old format; please change the password to the new format
Why does MySQL say connection using old ( pre-4.1.1 )?
Description: I’m receiving the following error: “Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)” When connecting to a Hostgator shared web server MySQL instance.
How to fix MySQL connection using old authentication protocol?
As reported previously, further actions such as import and export are NOT using this setting, and the action fails with an ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled) Useless resolution… using v6.1.6 CE
How to disable secure AUTH in MySQL Workbench 6.08?
A new option was added in the connection settings “Advanced” tab for disabling the secure_auth (useLegacyAuth) option, to optionally connect to legacy systems. For MySQL Workbench 6.08 in the Manage Server Connections, Connection tab, Advanced sub-tab you must check the box ‘Use the old authentication protocol.’
How to check ” use old authentication protocol ” in MySQL?
For MySQL Workbench 6.08 in the Manage Server Connections, Connection tab, Advanced sub-tab you must check the box ‘Use the old authentication protocol.’ I’ve got same problem in Centos 7 with MySQL. If i try to connect by mysql client:
How to disable secure AUTH in MySQL?
Add useLegacyAuth=1 in the Advanced options box in the connection settings dialog. On the command line, use something like the following, if you have no choice… A new option was added in the connection settings “Advanced” tab for disabling the secure_auth (useLegacyAuth) option, to optionally connect to legacy systems.
What is the error 1275 in MySQL?
ERROR 1275 (HY000): Server is running in –secure-auth mode, but ‘root’@’localhost’ has a password in the old format; please change the password to the new format I had similar issue, but using MAC Terminal connecting remote MySQL db. Solution: I create a new user with less special characters, that problem disappeared.