Installing and Configuring MySQL Community – Programming Code Examples
MySQL

Installing and Configuring MySQL Community2 min read

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:

  1. MySQL Server
  2. 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.

 

 

Leave a Comment