1- 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.
We will download and use the free MySQL package:
, after being downloaded and installed fully, includes parts as illustrated in the following image.
There are two most important things:
- MySQL Server
- MySQL Workbench (A visual tool to learn and work with MySQL)
To download MySQL Community, goto:
3- Install MySQL Community
Select all, including the example Database (For study purposes).
At this point the installer notifies you that your computer does 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 the "Execute" button.
At this time, all necessary libraries have been installed on your computer. Some libraries you may not need to use such as Connector/Python, you can skip it or manually install if you want. OK, click Next to continue to install MySQL:
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.
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.
The grant success.
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.
6- SQL Tutorial for Beginners with MySQL
Next, you can learn MySQL at: