Working with MySQL Workbench


I don’t want to repeat what has already been said by experts DBAs.  If you want to see a lot of “good” information about WorkBench, please visit: http://www.mysql.com/products/workbench/

What I could say is: “we need tools to improve our performance, and MySQL Workbench is one of them”.

So, I am going to describe how to setup a new connection, in order to play immediately with the Structured Query Language.

1) Open MySQL Workbench

Screen Shot 2015-02-18 at 20.18.16

2) Add a New connection

You can go to MySQL Connections and click on (+) icon. The Setup New Connection windows will be shown.

3) Setup New Connection

Screen Shot 2015-02-18 at 20.18.47

Connection Name: Give your new connection a name.

Connection Method: In my case, I am using a MySQL Server installed on SuSE Linux Enterprise 11 (VMWare).

Hostname: YOUR.MYSQL.SERVER.IP

Port: 3306

Username: (the mysql user)

Password: (the password for mysql user, not the Linux user)

Before clicking on OK, you can test if your data were correctly introduced by clicking on Test Connection

After clicking OK you should see your new connection:

Screen Shot 2015-02-18 at 21.35.21

4) Open the connection by clicking the area of your new connection. A new Tab is open:

Screen Shot 2015-02-18 at 20.34.20

5) Making queries

In the “sub”tab Query 1 we can write a query and run it by clicking on the lightning icon.

Screen Shot 2015-02-18 at 20.46.54

Normally, the first thing we have to do is to select the database we are going to work with. In this example:

Run the query. If you have the following message:

check if permissions have been granted for the involved user.

If all went well, you should see a green icon indicating the successfully execution of the query.

Screen Shot 2015-02-18 at 21.43.52

Now, you can play and go as deep as you can (and want).

For instance:

You will see:

Screen Shot 2015-02-18 at 20.47.31

 

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS