Software >> Services >> RDBMS >> Mysql >> How to get the plain text password from .mylogin.cnf for the user

 

[root@rhel7server1 ~]# pwd
/root

[root@rhel7server1 ~]# ls -lah .mylogin.cnf
-rw-------. 1 root root 696 May  4 11:59 .mylogin.cnf

[root@rhel7server1 ~]# my_print_defaults -s client
--socket=/mysql/data/rhel7server1/log/mysql.sock
--user=sysadmin
--password=PlainTextPassword
--host=localhost
--socket=/mysql/data/rhel7server1/log/mysql.sock