This post will tell you how to get MySQL passwords in plain text using the .mylogin.cnf file.
Since MySQL 5.6.6, it became possible to store MySQL credentials in an encrypted login path file named .mylogin.cnf, using the mysql_config_editor tool. This is better than in plain text anyway.
What if I need to read this password in plain text?
Perhaps because I didn’t save it? It might be that I don’t need it for long (as I can reset it), but it’s important that I get it.
Unfortunately (or intentionally),
mysql_config_editor
doesn’t allow it.
[root@db01 ~]# cat /root/.mylogin.cnf
????uUd????ٞN??3k??ǘ);??Ѻ0
?'?(??W.???Xܽ<'?C???ha?$
?? …[Read more]