Menu
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 :-/
949
d/mysql start 2>&1|grep my. cnf should show you the system call used to open the file.
MySQL looks for it in the following locations (in this order): %PROGRAMDATA%\MySQL\MySQL Server 5.7\my. ini , %PROGRAMDATA%\MySQL\MySQL Server 5.7\my. cnf.
Try: nano /etc/mysql/my. cnf and put these values. Where DBUSERNAME, DBPASSWORD, DBSERVER and DBNAME should be replaced with your own correct database username, database hostname, database name and database password. You will not have any of these until you create a database through your Control Panel.
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
188
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
