MySQL Server Administration Using Workbench

| Last Updated: | In: Mysql


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.


About: Prem Tiwari

Prem Tiwari is the founder of freewebmentor.com and is a professional developer who has vast experience in PHP and open source technologies. Apart from this, he is a blogger by hobby.


You may also like:


,