MySQL Server Administration Using Workbench

In this article, I will explain the MySQL Workbench for administrative functions of Mysql Server. Mysql bench could be a visual information configuration equipment that mixes SQL advancement, organization, information defined, creation and support into a solitary joined improvement surroundings for the Mysql information framework. MySQL Workbench provides Database Administrator (DBA) and developers an integrated tools for:

  • Database Designing & Modeling
  • SQL Development
  • Database Migration
  • Database Administration tools for server configuration, user administration, and much more

Getting Started with mysql workbench – Home Window

After installation of Workbench, go to your start menu and search “Workbench” and click on the icon to open Workbench application. This is the start-up/home screen of Mysql Workbench.

workbench1

Create a New Connection: MysqlConnection

You need to create a database connection to access your database. Now create a database. Now follow the below steps to create the new database connection as “MysqlConnection”.

workbench2

How to Create Your Own Database

Open the MYSQL Editor and then open a MySQL connection, which is created by you “MysqlConnection”. On this SQL tab, you can execute your mysql queries and see the results below the sql tabs. see the below screenshort.

workbench3

Over to You

If you still need any help to configure mysql wordkbench, then feel free to put your comments in below comment section. I will be happy to help to configure mysql wordkbench. Do you like & share this article with your friends, and don’t forget to follow us on Facebook and Twitter to learn cool WordPress tutorials.

If you like FreeWebMentor and you would like to contribute, you can write an article and mail your article to [email protected] Your article will appear on the FreeWebMentor main page and help other developers.

Recommended Posts:


Prem Tiwari

An engineer by profession and a passionate blogger by heart. Founder of FreeWebMentor.com (A Programming blog for beginners), Tech Speaker at various forums. A part from this he is an open source enthusiast, WordPress Lover, Blogger, SEO, and Growth Strategic.

Article Tags: ,