search

brittneybrinsfield / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

[REQ] When connecting over SSH allow an option to use the .my.cnf file in the user's home directory #1467

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Currently when connecting over SSH the user is required to enter login 
credentials in Sequel Pro even if the login credentials exist in the SSH user's 
home directory (typically defined in a .my.cnf).

Implementing this feature might be as simple as not passing a -p (and -u) 
parameter when connecting to mysql over SSH. A more complicated implementation 
might include a checkbox or input box in the connection dialog to specify if 
and/or which a mysql options file is used with the defaults-extra-file 
parameter when connecting.

Note that the user should be given the option to not use the .my.cnf in case 
they want to explicitly login with different credentials. This could be 
achieved through a checkbox as mentioned above, or by only using the .my.cnf 
file when no user/passowrd is specified in the connection dialog.

This feature allows database administrators to configure user credentials and 
ssh keys on the server and then allow the users to connect without specifying a 
password. While the password is still visible to the user if they ssh in and 
look at the .my.cnf file, the db administrator never has to e-mail or otherwise 
transmit the password to the user. This improves security and adds convenience.

Original issue reported on code.google.com by jeffv...@gmail.com on 19 Sep 2012 at 9:19

GoogleCodeExporter commented 9 years ago 
Sequel Pro uses SSH to do port forwarding - it does not somehow execute a 
remote 'mysql' command.
Actually there can be environments where it is not even possible to execute 
commands.

Looking through the mysql code it seems that it would actually possible to 
specify a defaults file (which would have to be fetched from the server first) 
but I don't think this is something many users would want.

Original comment by schlabbe...@gmail.com on 21 Sep 2012 at 7:59

GoogleCodeExporter commented 9 years ago 
I disagree, this is indeed very useful. Almost all my connections are tunneled 
through ssh, and having to manually login to lookup the credentials from the 
.my.cnf is cumbersome.

Original comment by Felix.Bu...@gmail.com on 22 Oct 2012 at 12:55