Permanently save login password for mysql client

 If you find it a nuisance to constantly type the mysql password while working with mysql, you can tell it to save, and thereafter it won't ask for it. WARNING. This exposes your database to hackers in that if they gain access to your account, your copy of mysql is also vulneralble.

The command is:

mysql_config_editor set --host=localhost --user=<whoever> --password


Comments

Popular posts from this blog

dump a specific table

mysql says you can't login as root but you have definitely got the right password

completely erase and reinstall mysql script.