MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. MySQL is a database management system. MySQL databases are relational. MySQL software is Open Source. The MySQL Database Server is very fast, reliable, scalable, and easy to use. MySQL Server works in client/server or embedded systems. A large amount of contributed MySQL software is available. – by dev.mysql.com
MySQL is a very famous and popular open source relational database management system. Installing MySQL on Windows 10 is very easy and straight forward. This blog will help you the step by step procedure to install the MySQL on Windows 10.
We can download the MySQL latest version installer from the MySQL official site. The download page has been given below.
Scroll down to the page, select the operating system “Microsoft Windows” and download the “mysql-installer-web-community-220.127.116.11.msi” installer by skipping the MySQL login.
After downloaded the installer, right click it and click “Install”.
MySQL Installation will starts now.
Accept the License Agreement and click “Next”.
Choose the Setup Type “Full” and Click “Next”.
Click “Next” on Check Requirements window.
Click “Yes” if any confirmation screen prompted by the installer. (If the Python 3.7 is not installed).
Click “Execute” button on the Installation window.
All MySQL Products will start download and install automatically. After complete all the products then, click “Next” to continue.
On the High Availability window, choose “Standalone MySQL Server/ Classic MySQL Replication” and click “Next” to continue.
type and networking
On the Type and Networking window, Select your Server Config Type based on your choice.
I have selected the Server Config Type is “Development Computer” and the default port number is 3306. If you want to run the MySQL on different port number than change it. Otherwise leave it as 3306 and click “Next” to continue.
On the Authentication method window, select the option “Use Strong Password Encryption for Authentication (RECOMMENDED)” to access the MySQL safely. Then click “Next” on the window to continue.
account and roles
On the Account and Roles window, provide the password for “root” user and click “Check” button to validate the password and then click “Next” button to continue.
On the windows service screen, Check the option “Configure MySQL Server as a Windows Service”, then provide the Windows the Service Name “MYSQL80”, then check the option “Start the MySQL Server at System Startup”, then check the option “Standard System Account” to run Windows Service as and then click “Next” button to continue.
Click “Execute” button to apply the MySQL configuration.
After applied the configuration for MySQL and then click “Finish” button to continue.
product configuration (Optional)
On the Product Configuration window, click “Next” button to configure the MySQL Router, Sample and Examples.
Click “Finish” button to continue with default options on the MySQL Router configuration window.
Click “Next” on the Product Configuration window to configure the Samples and Examples.
Provide the root password to check the connection and then click “Next” button to continue.
Click “Execute” button to apply the configuration and run the sample and examples SQL scripts.
Click “Finish” on the Apply Configuration window, click “Next” on the Product Configuration and click “Finish” on the Installation complete window.
MySQL Workbench will open automatically after clicked the “Finish” button.
Click “Local Instance MySQL 55” and provide the password and click “OK” to connect the server.
Execute the “show databases” command on the SQL editor to view the list of databases.
MySQL 8.0 has been installed successfully on windows 10.