Configuring MySQL .my.cnf

vi ~/.my.cnf

Add following content

[client]
user = root
password = "DBPASSWORD"
 
[mysqladmin]
user = root
password = "DBPASSWORD"
 
[mysqldump]
user = root
password = "DBPASSWORD"

Replace DBPASSWORD with your MySQL root password.

Now set permission for this file to 600, so no user other than root can see it.

chmod 600 ~/.my.cnf