Thursday, February 19, 2015

mysql cli password - mysql_config_editor

mysql_config_editor set --login-path=storedPasswordKey --host=localhost --user=root --password


How do I execute a command line with a secure password??
use the config editor!!!

As of mysql 5.6.6 you can store the password in a config file and then execute cli commands like this....

mysql --login-path=storedPasswordKey ....

--login-path replaces variables... host, user AND password.
excellent right!