Activities

July 2014
M T W T F S S
« Jun   Aug »
 123456
78910111213
14151617181920
21222324252627
28293031  

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol

While I’m accessing MySQL server 5.5 remotely from a windows server which was MySQL 5.6 libraries installed, I got the following errors.

C:\Documents and Settings\Administrator>mysql -h 192.168.10.24 -ureadusr -p
Enter password: ************
ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref
used (client option 'secure_auth' enabled)

How do I skip this error and able to connect the real server,
Solution
You may use “–skip-secure-auth” along with the mysql command to get ride this error.

C:\Documents and Settings\Administrator>mysql --skip-secure-auth  -h 192.168.10.
24 -ureadusr -p
Enter password: ************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3636
Server version: 5.5.25a-log MySQL Community Server (GPL)

Another approach is to solve this error permanently, you may need to use “skip-secure-auth” in your client mysql server config. file. I assume that MySQL 5.6 or Newer will not permit to connect a remote server over a plain text mechanism since anyone who can filter the tcp packet can read the auth details easily.

Open your my.cnf and edit the following file. Then re-open the new command window and execute.

[mysqld]
skip-secure-auth

Cheers !! 🙂

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>