Site icon AWS: © LimitlessV, Software Development Solutions.

Using Option Files .My.Cnf – Mysql User & Password


Warning!

If someone gains access to your account they will be able to easily escalate to root privileges.


Create file ~/.my.cnf and add the following lines in it and replace mysqluser & mysqlpass values.

[client]
user=mysql_user_name
password=mysql_password

For safety, make this file readable to you only by running chmod 0600 ~/.my.cnf

Purpose

Next time you run mysql commands mysqlmysqlcheckmysqdump, etc; they will pick username & password from this file if you do not provide them as argument (-u and -p). It can save your time.

Of-course, if you specify username and password explicitly as part of commands arguments, they will be used.

Exit mobile version