1- Summary versions of MySQL
There is 2 version of MySQL:
- MySQL Cummunity: The free version. (We will install this version).
- MySQL Enterprise Edition: The commercial version.
2- Download MySQL
We will download and use the free MySQL package:
- MySQL Community Server
MySQL Community, after being downloaded and fully installed, includes the parts shown in the following image.
There are two most important things:
- MySQL Server
- MySQL Workbench (A virtual tool to learn and work with MySQL)
To download MySQL Community, go to:
The download result:
3- Install MySQL Community
Select all, including the sample database (for study purposes).
At this point you should not have the necessary libraries installed. So if you click “Next” to continue the installation may be faulty during installation.
Click on the required libraries and click on the “Execute” button.
At this time, all necessary libraries have been installed on your computer. Some libraries you may need to use this Connector / Python, you can do it or install it if you want. OK, click Next to continue to install MySQL:
The installer displays a list of packages to install.
The installer continues to the configuration section of the MySQL Server.
Continue the configuration for examples of the database:
Enter the password and click Check to test the connection with MySQL.
Click Finish to complete the installation.
4- Configure MySQL
The connection with MySQL from another computer can be blocked. You must configure it for the other computer to connect to your MySQL.
Our goal is to grant permission to access MySQL to a user from any IP address.
The success of the grant.
5- Using MySQL Workbench
Open MySQL Workbench:
Image of MySQL Workbench with some examples of the database.
Install this SCHEMA as the default for working.
Then create a table, and insert a line in that table.