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
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