Installing and configuring MySQL Community

View more categories:

1- Introduction

This document is based on:
  • Window 7 (64bit)

  • MySQL Community 5.6.21

2- Summary versions of MySQL

There are 2 versions of MySQL:
  • MySQL Cummunity
  • MySQL Enterprise Edition
MySQL Cummunity: The free version. (We will install this version).
MySQL Enterprise Edition: A commercial version.

3- Download MySQL

We will download and use the free MySQL package:
  • MySQL Community Server
MySQL Community, after being downloaded and installed fully, includes parts as illustrated in the following image.
There are two most important things:
  1. MySQL Server
  2. MySQL Workbench   (A visual tool to learn and work with MySQL)
To install MySQL Workbench, you must install two libraries required:
Thus, you have to download 2 libraries and install them before starting to install MySQL Community.
To download MySQL Community, goto:

3.1- Download: MySQL Community Server (GPL)

3.2- Results download

4- Install

4.1- Install the required libraries

First, you have to install two expanding libraries as above mentioned.

4.2- Install MySQL Community

Select all, including the example Database (For study purposes).
In this step, the installment set checks requiring libraries. It notifies the missing:
  • Visual Studio Tools for Office ... & Python 3.4.
However, we can ignore it (as it is unimportant)
The installer displays a list of packages to be installed.
The installer continues to MySQL Server configuration section.
Continue configuration for examples database:
Enter the password and click Check to test the connection with MySQL.
Click Finish to complete the installation.

5- Configure MySQL

The connection with MySQL from another computer can be blocked. You need to configure it so that other computer can connect to your MySQL.
Our objective is to assign the authority of accessing to MySQL to a user from any IP address.
-- Syntax:
GRANT ALL ON *.* to [email protected]'%' IDENTIFIED BY 'mypassword';

-- Note: The 'root' user is available after installing MySQL.
GRANT ALL ON *.* to [email protected]'%' IDENTIFIED BY '1234';
The grant success.

6- Using MySQL Workbench

Open MySQL Workbench:
MySQL Workbench with several example database:
We create a database with the name: mytestdb.
Setup this SCHEMA as default to work.
Next create a table, and insert one row into it.
-- Create table.
Create table My_Table (ID int(11), Name Char(64)) ;

-- Insert one row.
Insert into My_Table (id,name)
values (1, 'Tom Cat');

7- SQL Tutorial for Beginners with MySQL

Next, you can learn MySQL at:

View more categories: