How To Install Mysql Community Server On Windows
In this tutorials, I am going to show how to install Mysql on Windows 10 operating system.
Install Mysql on Windows ten:
I hope this footstep past footstep process to install Mysql on Windows 10 will help y'all better.
Version Information:
- Windows 10 Pro
- Mysql Customs Server eight.0.12
Step 1:
Download the latest Mysql Customs server from MySQL official website. For me, it is 8.0.12, if the version differs you no problem the installation steps volition be the same.
By clicking on the higher up URL, you will see the below options. Select your operating organization (Microsoft Windows) and click on Get to Download Folio. It will redirect you the actual download folio for windows Mysql server.
Step 2:
It will testify you More often than not Available (GA) Releases. Where nosotros tin encounter two different installers, one is a web community installer which comes as a little file and some other ane is MySQL installer community. Click the Download button on the second i (mysql-installer-customs).
Step three:
Information technology will inquire your MySQL credentials to download the .msi file. If you take your credentials, you lot can log in or else if you wish to sign upwardly at present you can click on the green coloured signup button.
If you are not interested in login or sign up for now, you can straight go and click onNo thanks, only outset my download option. It will download selected MySQL for you on your local machine.
Footstep 4:
Get to your downloads folder where you lot tin can run into the mysql-installer-community file, right click on that file and click Install option.
Pace 5:
This window configures the installer, in the centre, it may inquire you lot for permissions to change your computer settings or firewall confirmation, you lot tin can have and so it volition accept a few seconds to configure the installer.
Step vi:
Read the license understanding and accept the license terms.
Step 7:
This window provides y'all to set different types of MySQL installations. You can set up Mysql in 5 different types equally provided beneath. Now I am selecting the Developer Default as I am a developer so that I demand all the products which help my evolution purposes. Click on Adjacent.
Step viii:
Based on your Windows configuration, information technology may prompt you like "Ane or more product requirements have not been satisfied". You tin can only click on Yeah.
Step nine:
Click on Execute.
Step 10:
Upon execution of the previous step, the installer grasps all recommended products in place and asking for our approval to execute the production installation procedure. Click on Execute.
Step 11:
Upon successful execution of all required products, now the MySQL allows us to configure the server settings. Click on Nextto configure the server.
Footstep 12:
This step allows you to configure the server. Nosotros can gear up the server in two different modes. One is a standalone mode, and another 1 is cluster mode. I don't want to arrive as a cluster because I am installing MySQL for development purpose so that I am selecting Standalone MySQL server and click on Next.
Stride 14:
Choose the Evolution Figurer choice from Config Type drop-down. You can find the following controls like TCP/IP, Port and Ten Protocol Port. If y'all wish to configure your port, y'all can change here itself and click on Next. For now, I am leaving as its default configuration.
Step xv:
Information technology is prompting you to select the authentication method, leave information technology every bit the default recommended method and click on Next.
Footstep 16:
Hither you can gear up your MySQL root user password. If you wish to create a new user, you can click on Add together User push under MySQL user accounts section.
Step 17:
Upon clicking on Add User push button, y'all will get the user details popup which allows you to create a new user business relationship. Afterward creating the user click on Next.
Stride 18:
Get out the service details as default and click on Side by side.
Step xix:
Printing Execute to use the configurations on the previous step.
Step 20:
Upon execution, you can see the below green coloured ticks on every configuration selection and finally you lot will getFinish button.
Click on Finish you got your MySQL on your Windows 10 operating arrangement.
Testing:
Search for MySQL in your taskbar search item. At that place you lot tin can run across all MySQL products which we installed and click on MySQL client; it will enquire your MySQL countersign to login, after successful login yous could run into the MySQL prompt like beneath.
MySQL comes along with some default databases. We can see the databases by using bear witness databases control.
We are completely done with the installation process, so at present let's create a table in information technology.
Happy Learning 🙂
Share a word.
Source: https://www.onlinetutorialspoint.com/mysql/install-mysql-on-windows-10-step-by-step.html
Posted by: lewislovence.blogspot.com
0 Response to "How To Install Mysql Community Server On Windows"
Post a Comment