Problem: Warning: Using a password on the command line interface can be insecure.
1 2 3 |
[root@slave /mnt/sql]$mysql -h10.10.141.31 -uuser -ppassword Warning: Using a password on the command line interface can be insecure. ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) |
fix:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
[root@slave /mnt/sql]$mysql -h10.10.141.31 -user -ppassword --skip-secure-auth Warning: Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 292489 Server version: 5.5.9-log MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> |
So, what do you think ?