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.

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”.

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.

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:

• Mysql database connection in python
• How to show the Store Procedure Code Syntax in MySQL
• How to change MySQL password
• How to Replace All Matched Fields in MySQL
• Working With MySQL Events – Complete Beginners Guide
• Best MySQL GUI Tools for Developers 2017
• Some Useful WordPress MySQL Queries
• How to get data from mysql using AngularJS and PHP
• Start using PDO instead of PHP MySQL extension
• How to Export Data in .CSV File From Mysql Using PHP

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: MySQL Server Administration Using Workbench, Workbench