Re: Capitalize Input via Auto Complete?
On Thu, Sep 16, 2010 at 2:35 PM, Todd Lyons tly...@ivenue.com wrote: On Wed, Sep 15, 2010 at 6:50 AM, Johan De Meersman vegiv...@tuxera.be wrote: I commonly set up a tunnel to the SSH server at the office and then another tunnel from that server to my development rig, so I can run MySQL WB at home on my database at work. Is that what you mean? Pretty much, yeah. I've not got just the one database, though, so it's usually too much of a bother to set up all the tunnels, and I just SSH straight through and use the commandline :-) Still, the SSH tunnel capability in the client is nice for hosts that are only one jump away. It works for multiple jumps too. You just have to enable X11 forwarding either in the appropriate config files or do it on the commandline. Note that it's possible that a severely paranoid sysadmin may well have disabled it in the sshd service on one or more of the machines that you're ssh'ing to. # my workstation has ForwardX11=yes in ~/.ssh/config ssh host1 # then from there: ssh -X host2 On host 2, running a gui app pops it up on my local desktop. You misunderstand me :-) I specified in the client, referring to the Workbench app, not the SSH client. ssh-level jumps have always been possible, and work with whatever too you want them to. The convenience of the Workbench-integrated jump, is that I don't have to bother setting up the tunnel manually, remember what particular host I tied to what particular local IP/port combo, et cetera. I've not just the one server to admin, you know - I just ordered 20 licenses for ZRM backup, to cover the most important machines. The rest of them aren't important enough to warrant that cost, they'll manage fine with a nightly dump. So, as I said; I use workbench (occasionally) for hosts that are 0 or 1 jump away; for the rest I just go there through plain SSH and do stuff commandline. -- Regards... Todd I seek the truth...it is only persistence in self-delusion and ignorance that does harm. -- Marcus Aurealius -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Capitalize Input via Auto Complete?
On Wed, Sep 15, 2010 at 6:50 AM, Johan De Meersman vegiv...@tuxera.be wrote: I commonly set up a tunnel to the SSH server at the office and then another tunnel from that server to my development rig, so I can run MySQL WB at home on my database at work. Is that what you mean? Pretty much, yeah. I've not got just the one database, though, so it's usually too much of a bother to set up all the tunnels, and I just SSH straight through and use the commandline :-) Still, the SSH tunnel capability in the client is nice for hosts that are only one jump away. It works for multiple jumps too. You just have to enable X11 forwarding either in the appropriate config files or do it on the commandline. Note that it's possible that a severely paranoid sysadmin may well have disabled it in the sshd service on one or more of the machines that you're ssh'ing to. # my workstation has ForwardX11=yes in ~/.ssh/config ssh host1 # then from there: ssh -X host2 On host 2, running a gui app pops it up on my local desktop. -- Regards... Todd I seek the truth...it is only persistence in self-delusion and ignorance that does harm. -- Marcus Aurealius -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Capitalize Input via Auto Complete?
On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent dae...@daevid.com wrote: You do know you can use ssh tunnels and such to connect to your server from your desktop right? I do it all day long. It's pretty easy to do and built in to these programs. You can't multi-jump, though. Yes, that's common in my environment :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Capitalize Input via Auto Complete?
Johan De Meersman wrote: On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent dae...@daevid.com wrote: You do know you can use ssh tunnels and such to connect to your server from your desktop right? I do it all day long. It's pretty easy to do and built in to these programs. You can't multi-jump, though. Yes, that's common in my environment :-) What do you mean by multi-jump? I commonly set up a tunnel to the SSH server at the office and then another tunnel from that server to my development rig, so I can run MySQL WB at home on my database at work. Is that what you mean? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Capitalize Input via Auto Complete?
On Wed, Sep 15, 2010 at 3:39 PM, george larson george.g.lar...@gmail.comwrote: I commonly set up a tunnel to the SSH server at the office and then another tunnel from that server to my development rig, so I can run MySQL WB at home on my database at work. Is that what you mean? Pretty much, yeah. I've not got just the one database, though, so it's usually too much of a bother to set up all the tunnels, and I just SSH straight through and use the commandline :-) Still, the SSH tunnel capability in the client is nice for hosts that are only one jump away. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Capitalize Input via Auto Complete?
I am new to MySQL coming from PostgreSQL noticed a really annoying issue. When I select a database, and try to auto complete in MySQL, it doesn't capitalize the MySQL statements. It's irritating to me to only be able to auto complete statements like 'SELECT', 'ALTER', 'INSERT' only if I hold down the shift key or caps lock key while typing. Is there a way to force MySQL to auto complete commonly used statements while typing them in lowercase which is normal behavior in PostgreSQL? Thanks for any info! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Capitalize Input via Auto Complete?
Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. -Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Tuesday, September 14, 2010 9:03 AM To: MySQL Subject: Capitalize Input via Auto Complete? I am new to MySQL coming from PostgreSQL noticed a really annoying issue. When I select a database, and try to auto complete in MySQL, it doesn't capitalize the MySQL statements. It's irritating to me to only be able to auto complete statements like 'SELECT', 'ALTER', 'INSERT' only if I hold down the shift key or caps lock key while typing. Is there a way to force MySQL to auto complete commonly used statements while typing them in lowercase which is normal behavior in PostgreSQL? Thanks for any info! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Capitalize Input via Auto Complete?
Daevid Vincent wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. Alternatively, there is MySQL WorkBench. Some of the guys around here use SQLYog but, since it is a LAMP environment, I like that WorkBench is native instead of dealing with wonky Wine issues. I haven't noticed anything that I miss from SQLYog yet. -Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Tuesday, September 14, 2010 9:03 AM To: MySQL Subject: Capitalize Input via Auto Complete? I am new to MySQL coming from PostgreSQL noticed a really annoying issue. When I select a database, and try to auto complete in MySQL, it doesn't capitalize the MySQL statements. It's irritating to me to only be able to auto complete statements like 'SELECT', 'ALTER', 'INSERT' only if I hold down the shift key or caps lock key while typing. Is there a way to force MySQL to auto complete commonly used statements while typing them in lowercase which is normal behavior in PostgreSQL? Thanks for any info! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Capitalize Input via Auto Complete?
On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. I can't use any graphical or 3rd party add-on's. I was hoping MySQL had this native / built in. I guess not... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Capitalize Input via Auto Complete?
Carlos Mennens wrote: On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. I can't use any graphical or 3rd party add-on's. I was hoping MySQL had this native / built in. I guess not... There's some impressive stuff built for VIM, but my VIM-fu is still pretty weak. This is script, though. [ http://www.vim.org/scripts/script.php?script_id=356 ]
Re: Capitalize Input via Auto Complete?
On Tue, 2010-09-14 at 15:45 -0400, george larson wrote: Daevid Vincent wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. Alternatively, there is MySQL WorkBench. Some of the guys around here use SQLYog but, since it is a LAMP environment, I like that WorkBench is native instead of dealing with wonky Wine issues. I haven't noticed anything that I miss from SQLYog yet. I've been using sqlyog on wine for a while now, with no issues. it has never crashed, or caused errors in anyway. I am on Ubuntu 9.10 (it wants to uninstall wine to upgrade to 10.04, so for now i am not upgrading) Steve -Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Tuesday, September 14, 2010 9:03 AM To: MySQL Subject: Capitalize Input via Auto Complete? I am new to MySQL coming from PostgreSQL noticed a really annoying issue. When I select a database, and try to auto complete in MySQL, it doesn't capitalize the MySQL statements. It's irritating to me to only be able to auto complete statements like 'SELECT', 'ALTER', 'INSERT' only if I hold down the shift key or caps lock key while typing. Is there a way to force MySQL to auto complete commonly used statements while typing them in lowercase which is normal behavior in PostgreSQL? Thanks for any info! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Capitalize Input via Auto Complete?
-Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Tuesday, September 14, 2010 12:54 PM To: MySQL Subject: Re: Capitalize Input via Auto Complete? On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. I can't use any graphical or 3rd party add-on's. I was hoping MySQL had this native / built in. I guess not... Is there some reason you can't use a graphical tool? You do know you can use ssh tunnels and such to connect to your server from your desktop right? I do it all day long. It's pretty easy to do and built in to these programs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
