Tag Archives | toad

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.

MySQL Tutorial for beginners

MySQL Tutorial for beginners

********************************************************
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.
Continue Reading →

Continue Reading >>

MySql Tutorial for Beginners Part 4 – CREATE Statement MySql

Welcome to MySQL Tutorial for Beginners part 4. Today we will create a database. And Create some Data.We are going to start using MySQL commands. Before we start we need to have some sort of Data.We are going to create some sample data. By now you should have required Software and Utilities for MySQL Installed on your PC. If not check earlier MySQL Tutorial for Beginners part 3.

MySQL Tutorial for beginners

MySQL Tutorial for beginners

Start MySQL Community Server,Toad or Sequel Pro on you computer. Then we are going to create a new connection to database server. Follow the steps below:

Connecting Toad to MySQL community server:
For Toad go to File > New > Connection. Then you will see a new connection window like the picture below.
Toad New Connection

From the Connection Type select TCP. You can select connection type such as TCP, SSL, SSH, HTTP Tunnel . We will use TCP connection.

Here are the information to make new connection using Toad for MySQL.
Connection Type: TCP
Host :  localhost
User :  root
Password: Type in your Password
Database: test

If you want to save the connection fill out the details at the bottom of the window.
Continue Reading →

Continue Reading >>

Some Tools and Utilities for MySQL Tutorial for Beginners Part 3

Hello everyone welcome to MySQL tutorial for beginners part Three. Before starting MySQL we are going to see some tools and utilities for MySQL.We will these tools for the rest of the MySQL tutorial.
MySQL

Some Tools and Utilities for MySQL Tutorial

There are many kinds of software available to manage database. We are going to use GUI instead of command-line interface for MySQL Tutorial. We will need the tools below :

1. Notepad++ : Notepad++ is one of the most widely used free source code editor for programming languages. Such as HTML, MySQL,PHP,CSS and lots more.
Notepad++

Notepad++ is windows Application but there is a way to install Notepad++ in MAC OSX. Download links for Notepad++ are bellow:

For Windows Users : http://notepad-plus-plus.org/download/
Download Notepad++ For Mac : http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=Notepad%2B%2B_And_Unix/Mac
Continue Reading →

Continue Reading >>