Mysql server is an opensource database system. You can use very easy to install on windows any version. Goto download zip and install quickly. Mysql workbench download msi for connect your mysql server. Now I have to show how to install mysql community on windows 10.
★ How To Configure Static IP address On Ubuntu 18.04
★ How To Install Zabbix Server On Ubuntu 18.04
Requirements for install mysql server on windows:
- Microsoft .NET Framework 4.5
- Microsoft Visual C++ 2015 Redistributable Package
Step #01: Run downloaded msi file with admin privileges.
Choosing a Setup Type Server only
then click Next button.
Now you can see Requirements details.
if you can’t install microsoft dotnet and Microsoft Visual C++ click Execute button and get resolved when complete installed software.
Step#2: Now main installation process start. Click here Next two times now show mysql root user password. Another adding mysql user click Add User. Example below image:
Step #03: Now click Next for Apply Configuration click Execute. Finally click Finish button.
Now Install mysql WorkBench
Step #04: Download mysql wordkbench. Now run downloaded msi file.
When installation completed then connect your local mysql server. Write any connection name then click test connection. Enter mysql root password click OK
Connected to mysql to MYSQL at 127.0.0.1:3306 with user root.
Connection parameters are correct.
Step #05: Click OK and double click connection name. Example below:
Click Test Connection then show popup password window. Type your root password click ok.
Connected to MySQL at 127.0.0.1:3306 with user root
Connection parameters are correct.
Step #06: Then click database object connection name previously created. My connection name new. Bubble click on your connection name. Now open your mysql query terminal.
Create database command on MySQL:
create database product;
Then execute your db command.
Create table command on MySQL:
create table item (c int);
Then execute your table command.
Enjoy your windows MuSQL service for testing purposes.
- How To Install Zabbix Server 6.4 On AlmaLinux 8 Server - August 9, 2024
- How To Clear RAM Memory Cache Buffer Linux Server - February 29, 2024
- How To Install Apache Cloud Stack Management Server 4.17 On Ubuntu 22.04 - February 1, 2024
Leave a Comment