Comments on: (More) Secure local passwords in MySQL 5.6 and up https://www.percona.com/blog/more-secure-local-passwords-in-mysql-5-6-and-up/ Fri, 12 May 2023 16:32:13 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: J.D. Fagan https://www.percona.com/blog/more-secure-local-passwords-in-mysql-5-6-and-up/#comment-10967994 Fri, 14 Apr 2017 16:08:00 +0000 https://www.percona.com/blog/?p=27013#comment-10967994 Does the utility, mysqldbcompare, support .mylogin.cnf? I can’t seem to make it work with either .mylogin.cnf or .my.cnf files. Only specifying the credentials on the command line is working for me with this utility.

This is how I’m invoking it via a wrapper script with the variables substition happening when I run it:
mysqldbcompare –disable-binary-logging –server1=${hostname1} –server2=${hostname2} ${host1_database}:${host2_database}

Note, I’m using Mac OS version installed via MySQL Workbench + MySQL Utilities:
$ mysqldbcompare –version
MySQL Utilities mysqldbcompare version 1.6.5
License type: GPLv2

]]> By: hikerVancouver https://www.percona.com/blog/more-secure-local-passwords-in-mysql-5-6-and-up/#comment-10967399 Mon, 28 Nov 2016 19:30:51 +0000 https://www.percona.com/blog/?p=27013#comment-10967399 One way:

sprintf_s(systemCommand,_countof(systemCommand), “\”%s\” set –host=%s –login-path=%s –user=%s –port=%d –password”,
mysqlConfigEditor,serverID,loginPath,userName,serverPort);
ret = system(systemCommand);
if (ret==0) //OK, file created and populated

where mysqlConfigEditor is a full path to “mysql_config_editor.exe”, and loginPath is a label naming this connection to the server in the file.

]]> By: kisl0tneg https://www.percona.com/blog/more-secure-local-passwords-in-mysql-5-6-and-up/#comment-10965968 Mon, 07 Mar 2016 15:38:16 +0000 https://www.percona.com/blog/?p=27013#comment-10965968 Hi

Is it possible to generate the .mylogin.cnf programmatically?
I’ve got a custom program that manages databases – sets up credentials, etc. and I would really like to write out the .mylogin.cnf from my code.

thanks!

]]> By: Stefan Lasiewski https://www.percona.com/blog/more-secure-local-passwords-in-mysql-5-6-and-up/#comment-10852744 Mon, 15 Jun 2015 20:25:37 +0000 https://www.percona.com/blog/?p=27013#comment-10852744 > Ok, so I’ve added a password, now I want to create my .my.cnf file:

FYI: This appears to be a typo. I think you meant to say “.mylogin.cnf” instead of “.my.cnf”.

]]> By: Fadi El-Eter (itoctopus) https://www.percona.com/blog/more-secure-local-passwords-in-mysql-5-6-and-up/#comment-10256747 Mon, 01 Dec 2014 16:50:52 +0000 https://www.percona.com/blog/?p=27013#comment-10256747 Hi Jay,

I like the idea of a stored password in a local my.cnf – personally I have never used it before.

Using the config editor to store login credentials is an excellent idea because the alternative will allow someone with root access to the server to just read the passwords (because they are stored unenrypted). But then again, I wonder if people actually care about security at this level, most of the phpMyAdmin installations out there have the MySQL root password stored in the the config file!

]]>