Opening terminal windows with bash

Question

I do a fair bit of work at the command line. When I start my computer up on of the first things I do is open up a terminal window for mysql, and one for the Rails console and usually a third running mongrel. Setting it up every morning is a bit of a drag so I would like to script it. How can I open a terminal window, log into mysql, select my development database and then leave it there at the mysql prompt waiting for me. I know how to execute a mysql statement from bash, I just don't know how to get it to leave the prompt open for me to work with after. Hopefully that is clear!

Update: Combining the two answers below got things working for mysql. Thanks!

Now I am trying to get a gnome-terminal window to stay open running the Rails script/server command so I can watch the output. For some reason the following closes almost immediately:

gnome-terminal  -e "ruby /home/mike/projects/myapp/script/server" &

What platform are you on? And what do you mean by a terminal? xterm? — anon
– anon, Commented Dec 17, 2009 at 10:52
Oops! Sorry! Running Ubuntu Karmic and opening up gnome-terminal windows. — mikewilliamson
– mikewilliamson, Commented Dec 17, 2009 at 10:55

mouviciel · Accepted Answer · 2009-12-17 10:56:46Z

1

xterm provides an option for executing a command:

xterm -e myCommandToLogIntoMysql &

You can put a sequence of such xterm commands into a shell script.

answered Dec 17, 2009 at 10:56

mouviciel

68k12 gold badges108 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

el.pescado - нет войне · Accepted Answer · 2009-12-17 11:08:58Z

0

How can I open a terminal window, log into mysql, select my development database and then leave it there at the mysql prompt waiting for me.

mysql -u user -ppassword -D database_name

Remember not to put space between "-p" and password. Note - this is a bit insecure, as your password is visible in process list so anyone can read it using ps. You can, however, put your MySQL password in ~/.my.cnf file.

answered Dec 17, 2009 at 11:08

el.pescado - нет войне

19.3k4 gold badges50 silver badges92 bronze badges

Comments

bfontaine · Accepted Answer · 2023-03-30 16:48:09Z

-1

How to correctly open a terminal in your bash script is

#!/bin/bash
    
term=$(/usr/bin/qterminal)

echo "$term"

edited Mar 30, 2023 at 16:48

bfontaine

21.3k14 gold badges88 silver badges127 bronze badges

answered Mar 26, 2023 at 11:39

Matheas Herbst

1

1 Comment

bfontaine Over a year ago

This doesn’t work if you haven’t installed qterminal.

Collectives™ on Stack Overflow

Opening terminal windows with bash

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related