Thursday 26 October 2017

Solved ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

A error occured when run `mysql` from the terminal to connect to a server.

Add `--skip-secure-auth` to the end of the statement
mysql -u repluser -p'myreplpass'  -hxx.xx.xx.xx --skip_secure_auth

MySQL access and replication blocked by secure_auth
Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

I have  tried to connect to a MySQL database and you see this error
On master server

select Password from mysql.user;
SELECT @@session.old_passwords, @@global.old_passwords;

+-------------------------+------------------------+
| @@session.old_passwords | @@global.old_passwords |
+-------------------------+------------------------+
|                       1 |                      1 |
+-------------------------+------------------------+
1 row in set (0.00 sec)

SET @@session.old_passwords = 0;
Query OK, 0 rows affected (0.00 sec)

GRANT REPLICATION SLAVE ON *.* TO 'repluser'@'xx.xx.xx.xx' IDENTIFIED BY 'myreplpass';
Query OK, 0 rows affected (0.00 sec)

try set strong password of replication user

No comments:

Post a Comment