HOME

What is MySQL?

MySQL is the most popular Open Source SQL database management system that is developed, distributed, and supported by Oracle Corporation. MySQL databases are relational. MySQL stores data in the form of tables that can be modified using Structured Query Language. MySQL Server works in client/server or embedded systems.

How to install MySQL on Windows?

Step 1 – Open the MySQL website on a browser. Click on the following link: 

https://dev.mysql.com/downloads/installer/

Choose the desired installer and click on download.

Step 2 – Select “No thanks. just start my download”.

Step 3 – After the download, open the installer.

Step 4 –  It will ask for permission; when it does, click Yes. The installer will then open. Now, it will ask to choose the setup type. Here, select Custom option. Click the “Next” button.

Step 5 – Select latest options from MySQL Servers, MySQL Workbench, and MySQL Shell and move them to right column “Products To Be Installed” using the arrow. Click the “Next” button.

Step 6 – Once all the selected products are installed, click on the “Execute” button.

Step 7 – Once the products will be downloaded, click the “Next” button.

Step 8 – The products are “Ready to Install”. Click on the “Execute” button.

Step 9 – Once the installations are completed, click on the “Next” button.

Step 10 – Configure the product. Click on the “Next” button.

Step 11 – Under Type and Networking, go with the default settings. Click on the “Next” button.

Step 12 – For authentication, use the recommended strong password encryption.

Step 13 – Set your MySQL Root password and click on the “Next” button.

Step 14 –  Go for the default windows service settings. Click on the “Next” button.

Step 15 – Select the default option for Server File Permissions. Click on the “Next” button.

Step 16 –  Under apply configuration, click on the “Execute” button.

Step 17 – Once the configuration is complete, click on the “Finish” button.

Step 18 – This screen shows that the Product Configuration is completed.

Step 19 – Complete the installation. This will now launch the MySQL Workbench and the MySQL Shell.

Step 20 – Once MySQL Workbench is installed, select the Local instance and enter the password.

Once MySQL has been successfully installed, the base tables have been initialized, and the server has been started, you can verify its working via some simple tests.

Open your MySQL Command Line Client; it should have appeared with a mysql> prompt. If you have set any password, write your password here. Now, you are connected to the MySQL server, and you can execute all the SQL command at mysql> prompt as follows:

Congratulations on making it through this tutorial and hope you found it useful! Happy Learning!! Cheers!!