How to avoid "use db_name" each time I start mysql

Question

Every time I start mysql, first query that I type is "use my_db_name" where my_db_name is the name of the database that I always use. I would like mysql to use my_db_name by default. Is there a way we can do that?

EDIT: I am connecting to mysql from command line.

while connecting to mysql you can pass the name of database as an argument i think. — codeomnitrix
– codeomnitrix, Commented May 14, 2011 at 8:22

PachinSV · Accepted Answer · 2011-05-14 08:23:27Z

5

In the options file (on windows my.ini, on linux my.cnf), in the Client section add the following:

database=db_name

answered May 14, 2011 at 8:23

PachinSV

3,7782 gold badges32 silver badges41 bronze badges

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

1 Comment

Vivek Pandey Over a year ago

Cool. That's what I was looking for. We need to put this directive in [mysql] section.

Henry · Accepted Answer · 2011-05-14 08:21:45Z

1

Just use

mysql -uuser -ppassword databasename

answered May 14, 2011 at 8:21

Henry

6,6402 gold badges26 silver badges30 bronze badges

1 Comment

Vivek Pandey Over a year ago

Ok. That is useful. However, I don't type "-uuser -ppassword" part since I have put username/password in /etc/my.conf. So, "mysql databasename" does the job for me. Further I can alias "mysql" to "mysql databasename" and then just happily type "mysql" on console.

Darin Dimitrov · Accepted Answer · 2011-05-14 08:21:53Z

0

You could specify the database when connecting:

mysql --user=root --password=secret --database=my_db_name

or directly:

mysql my_db_name

answered May 14, 2011 at 8:21

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

Collectives™ on Stack Overflow

How to avoid "use db_name" each time I start mysql

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related