MySQL Utilities - ~/.my.cnf option file

mysql passwords utilities
Carlton picture Carlton · Apr 30, 2013 · Viewed 95.4k times · Source

I am trying to use 2 of the mysql utilities, mysqldiff and mysqldbcompare and want to avoid putting my password on the command line

Is it possible to use an option file to specify the password for my DB connection to prevent me having to specify the password?

This is the sort of command that I currently have...

/usr/share/mysql-workbench/python/mysqldiff --server1=root@localhost --server2=root@localhost --difftype=sql db1:db2

I also have a file at ~/.my.cnf that has "600" permissions and contains the following..

[client]
user=root
password=mypassword

When I connect via the command line to MySQL it picks up the details in my option file but the mysql utilities don't :-/

Answer

Retraut picture Retraut · Nov 11, 2013

Try this - 

[client]
user=root
password="pass"

[mysql]
user=root
password="pass"

[mysqldump]
user=root
password="pass"

[mysqldiff]
user=root
password="pass"

Location for .my.cnf: ~/.my.cnf

Please refer to the manual page entitled Using Option Files

Related questions

How to log in to phpMyAdmin with WAMP, what is the username and password?

What does the word "root" mean in phpMyAdmin? Whenever I write localhost/phpmyadmin on the address bar, I am asked to enter a username and a password, but I don't know what they are. I don't remember when and where …

Read More
Setting the MySQL root user password on OS X

I just installed MySQL on Mac OS X. The next step was setting the root user password, so I did this next: Launch the terminal app to access the Unix command line. Under the Unix prompt I executed these commands: $ …

Read More
How to find out the username and password for mysql database

I've forgotten what I set as username and password for mysql database. How could I be able to find it out? I am using wamp server. I am a newbie in mysql.

Read More