MySQL Workbench - Define database in connection settings

Question

I was wondering whether there is a way to define a specific database in the connection setup of MySQL Workbench (I know this works with other database software). Sometimes I have a lot of different databases on one server and I only want to access one with one connection. Can I specify the database in the connection settings somehow?

Default Schema option :)

samiles
– samiles

2017-05-15 08:41:21 +00:00
Commented May 15, 2017 at 8:41 — samiles
– samiles, Commented May 15, 2017 at 8:41

RiggsFolly · Accepted Answer · 2017-05-15 08:57:35Z

3

YES, On the home tab Click the + in MySQL Connections. And put the database name in the Default Schema: when you fill in all the usual info about ip address etc

Now if you only want to see the one database, then create a new MySQL user account and only allow this new account access to this single database. Then change the connection to the database to use the newly created MySQL account.

I guess you are seeing all the databases because you are using the root account.

edited May 15, 2017 at 8:57

answered May 15, 2017 at 8:43

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

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

2 Comments

TheKidsWantDjent Over a year ago

Ahh, that's what this if for! I entered the name and when I connected, it pre-selected my database. But other databases were still displayed. Is there also a way to restrict the connection to only this single database?

RiggsFolly Over a year ago

Yes, give me a few seconds to add to answer

Collectives™ on Stack Overflow

MySQL Workbench - Define database in connection settings

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related