Thomas Henson

  • Data Engineering Courses
    • Installing and Configuring Splunk
    • Implementing Neural Networks with TFLearn
    • Hortonworks Getting Started
    • Analyzing Machine Data with Splunk
    • Pig Latin Getting Started Course
    • HDFS Getting Started Course
    • Enterprise Skills in Hortonworks Data Platform
  • Pig Eval Series
  • About
  • Big Data Big Questions

MySQL Workbench

May 23, 2012 by Thomas Henson 1 Comment

For over a month now I have been working with MySQL Databases exclusively. Before then I was a Microsoft SQL Server guy, so the switch from SQL Server Manager to MYPHPADMIN was tough. After two weeks of adjusting I stumbled upon MySQL Workbench 5.2 by MySQL. What a find! This product offers many more options than MYPHPADMIN. One of the features that I found very useful is the ability to manage Multiple Instances from one main location.

MySQL Workbench is an opensource application offered by MySQL(Oracle). I was able to easily download it from MySQL and install it. The instructions were easy to follow for both Mac and Windows.

Below is a screen shot of the Website where you can download MySQL Workbench. If you already have an instance of MySQL server installed, MySQL Workbench will find it and reference it. There is no need to worry about having two different installs of MySQL (good news no need to worry about port configuration, Workbench
will do the configuration).

Managing Existing Database with Workbench

After going through install process, open up Workbench and click the New Connection button.




 

This will popup the Setup New Connection screen, which is similar to an FTP page. The following fields will need to be filled

  1. Connection Name: Any Name of your choosing
  2. Connection Method: Typically Standard TCP/IP
  3. Host Name: Local Connection -> (check your settings)-> 127.0.0.1 Remote Connection: (Check with your Hosting Company this can be a pain sometimes)
  4. Port: Local ->(check your settings)->3306 Remote Connection (Check with your Hosting Company)
  5. Username: Self explanatory
  6. Password: Can be stored here or entered every connection
  7. Default Schema: If you have multiple databases you can default to one, but I would leave blank to see all Databases

“>Now press test the connection if it passes press OK, if not you need to troubleshoot your inputs.

 






From here you should have a listing of your databases listed in the left widget bar. Press the arrow key next to your database to see a listing of your tables. Once you can see the tables listed right click directly on the table to get editing options.  For example if you select Edit table you should see this pop up in your main window. From here you can edit your tables.



Another way to edit your tables is to right click again on the table and select View first 100 rows. Once selected a SELECT * query will be ran in the main window, but in the bottom of the window you have a menu similar to the previous one.


Finding MySQL Workbench is an awesome tool for Managing MySQL Databases. It gives developers a ton of options not present in PHPMYADMIN, for example creating Database Schema, Managing Multiple Database, Native Database Connections, and more. MySQL Workbench is not for everyone, but for the Database Geeks it is a powerful tool to have in your development kit.

***Next tutorial will focus on creating a Database Schema and Reverse Engineering a Database Schema with Workbench***

Filed Under: Database, MySQL, MySQL Workbench Tagged With: Database MySQL Workbench, ftp MySQL Workbench, Getting Started Workbench, MySQL, MySQL Workbench

Subscribe to Newsletter

Archives

  • February 2021 (2)
  • January 2021 (5)
  • May 2020 (1)
  • January 2020 (1)
  • November 2019 (1)
  • October 2019 (9)
  • July 2019 (7)
  • June 2019 (8)
  • May 2019 (4)
  • April 2019 (1)
  • February 2019 (1)
  • January 2019 (2)
  • September 2018 (1)
  • August 2018 (1)
  • July 2018 (3)
  • June 2018 (6)
  • May 2018 (5)
  • April 2018 (2)
  • March 2018 (1)
  • February 2018 (4)
  • January 2018 (6)
  • December 2017 (5)
  • November 2017 (5)
  • October 2017 (3)
  • September 2017 (6)
  • August 2017 (2)
  • July 2017 (6)
  • June 2017 (5)
  • May 2017 (6)
  • April 2017 (1)
  • March 2017 (2)
  • February 2017 (1)
  • January 2017 (1)
  • December 2016 (6)
  • November 2016 (6)
  • October 2016 (1)
  • September 2016 (1)
  • August 2016 (1)
  • July 2016 (1)
  • June 2016 (2)
  • March 2016 (1)
  • February 2016 (1)
  • January 2016 (1)
  • December 2015 (1)
  • November 2015 (1)
  • September 2015 (1)
  • August 2015 (1)
  • July 2015 (2)
  • June 2015 (1)
  • May 2015 (4)
  • April 2015 (2)
  • March 2015 (1)
  • February 2015 (5)
  • January 2015 (7)
  • December 2014 (3)
  • November 2014 (4)
  • October 2014 (1)
  • May 2014 (1)
  • March 2014 (3)
  • February 2014 (3)
  • January 2014 (1)
  • September 2013 (3)
  • October 2012 (1)
  • August 2012 (2)
  • May 2012 (1)
  • April 2012 (1)
  • February 2012 (2)
  • December 2011 (1)
  • September 2011 (2)

Tags

Agile AI Apache Pig Apache Pig Latin Apache Pig Tutorial ASP.NET AWS Big Data Big Data Big Questions Book Review Books Data Analytics Data Engineer Data Engineers Data Science Deep Learning DynamoDB Hadoop Hadoop Distributed File System Hadoop Pig HBase HDFS IoT Isilon Isilon Quick Tips Learn Hadoop Machine Learning Machine Learning Engineer Management Motivation MVC NoSQL OneFS Pig Latin Pluralsight Project Management Python Quick Tip quick tips Scrum Splunk Streaming Analytics Tensorflow Tutorial Unstructured Data

Follow me on Twitter

My Tweets

Recent Posts

  • Tips & Tricks for Studying Machine Learning Projects
  • Getting Started as Big Data Product Marketing Manager
  • What is a Chief Data Officer?
  • What is an Industrial IoT Engineer with Derek Morgan
  • Ultimate List of Tensorflow Resources for Machine Learning Engineers

Copyright © 2023 · eleven40 Pro Theme on Genesis Framework · WordPress · Log in

 

Loading Comments...