Is it possible to have passwords configured per database or per host in .my.cnf

Question

I have the following in my ~/.my.cnf

[client]
password="somepass"

but this is not the password I use for every user@host/database I connect to. Is there some way to specify in the config different passwords for different things so I don't have to type them in?

score 83 · Accepted Answer · edited Apr 13 '17 at 12:42

83

As I answered here, you can add a section for each user/host/db you connect to using the syntax in your ~/.my.cnf:

[clienthost1]   # Note: client + host1
user=myuser
password=mypass
database=dbname
host=server.location.com

Once this is in your user's .my.cnf, you can utilize it by doing this on a command line:

$ mysql --defaults-group-suffix=host1

edited Apr 13 '17 at 12:42

Community

1

answered Aug 23 '11 at 13:30

Derek Downey

23,568
11
79
104

the · Answer 2 · 2016-08-20T11:14:29.290

11

The other answer is correct. Unfortunately mysqladmin doesn't support --defaults-group-suffix (at least not the version I'm using).

Hence I resorted to using --defaults-file=HOST.cnf instead, which works for mysql, mysqladmin and mysqldump.

edited Aug 20 '16 at 11:14

answered Jun 18 '15 at 12:43

the

343
1
3
12

score 10 · Answer 3 · answered Jun 18 '15 at 13:50

Put clear passwords in text files is not recommended since mysql 5.6.6.

You can use mysql_config_editor to save passwords encrypted also to provide different passwords for different connections https://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html

Is it possible to have passwords configured per database or per host in .my.cnf

3 Answers3