skimeer |
09-03-2015 08:58 AM |
What's is difference between changing MySQL user password with and without -h option
I have observed that for normal (other than root) user changing password with and without -h option has different effect. If password is changed without -h, then the commands used with -h did not pick new password. They still uses old password.
Also I am not able to connect to MySQL instance using -h option with root user. I am using MySQL Ver 14.14 Distrib 5.6.21, for Linux (x86_64) using EditLine wrapper
I am trying below command,
Quote:
[test@test ~]$ mysql -uroot -ptest -h 192.168.209.117
Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'test' (using password: YES)
|
Output of "SHOW GRANTS"
Quote:
mysql> show grants;
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql>
|
|