Import sample database using MySQL workbench – MySQL Tutorial Part 6

This tutorial is about how to import sample database in MySQL Workbench. And how to make new connection on Toad for MySQL after creating database on MySQL. If you are new here then you need to read the tutorials from the links below.

********************************************************
We started MySQL Beginers Tutorial

MySQL Beginners Tutorial Introduction Part 1

MySQL Command Types MySql Tutorial for Beginners Part 2

Some Tools and Utilities for MySQL Tutorial for Beginners Part 3

MySql Tutorial for Beginners Part 4 – CREATE Statement

MySQL Naming Guidelines -MySQL Tutorial Part 5

*********************************************************

To create / Import sample database, You will need to download Sample Employee Database For MySQL.

Download from Here :

Sample Employee Database for MySQL

You need to have MySQL and toad installed on your system . Now follow this Video tutorial to create new database using MySQL Workbench:

Here Are the steps to create new database for MySQL Workbench :

1. Click on Start Menu and start MySQL Workbench. Now Click on localhost to open new connection.

2. Now Click the “open a script File Editor” on MySQl Workbench

3. Now locate the sample sql file you downloaded from Bytetips.com. And open the file. Now click on Execute button to execute the script.

Here Are the steps to create new connection for Toad for MySQL  :

1. Click on Start Menu and start Toad for MySQL . Now Click on create a new connection.

2. Now you will see Create New connection Window. Put now fill up the information:

Connection Type::  TCP

For us  the information was:
Host:: localhost

User:: root

Password:: blank

Database :: btemployee

port:: 3306

3. Now Click on Connect button to connect the database using Toad.