How To Setup Mysql Database In Windows 10
In this tutorials, I am going to show how to install Mysql on Windows x operating system.
Install Mysql on Windows 10:
I hope this footstep past footstep process to install Mysql on Windows 10 will assistance you lot amend.
Version Information:
- Windows 10 Pro
- Mysql Community Server 8.0.12
Step 1:
Download the latest Mysql Customs server from MySQL official website. For me, it is viii.0.12, if the version differs yous no trouble the installation steps will be the same.
By clicking on the to a higher place URL, y'all will see the below options. Select your operating organization (Microsoft Windows) and click on Become to Download Folio. It will redirect y'all the actual download page for windows Mysql server.
Step 2:
Information technology will show y'all Generally Bachelor (GA) Releases. Where we tin run into ii unlike installers, ane is a web community installer which comes as a little file and another one is MySQL installer community. Click the Download button on the second one (mysql-installer-community).
Stride 3:
Information technology will ask your MySQL credentials to download the .msi file. If y'all take your credentials, you tin log in or else if you lot wish to sign upwards now you tin can click on the light-green coloured signup button.
If you lot are not interested in login or sign upward for now, you can direct get and click onNo thanks, merely start my download option. It will download selected MySQL for you on your local automobile.
Step 4:
Go to your downloads folder where you can see the mysql-installer-community file, right click on that file and click Install option.
Step five:
This window configures the installer, in the middle, it may ask yous for permissions to modify your reckoner settings or firewall confirmation, yous can have and and so information technology will take a few seconds to configure the installer.
Step 6:
Read the license agreement and accept the license terms.
Step 7:
This window provides you to set up different types of MySQL installations. You can set up Mysql in v different types as provided below. Now I am selecting the Developer Default as I am a developer so that I need all the products which help my development purposes. Click on Side by side.
Step 8:
Based on your Windows configuration, information technology may prompt you similar "I or more product requirements have not been satisfied". You can just click on Yep.
Step 9:
Click on Execute.
Footstep x:
Upon execution of the previous step, the installer grasps all recommended products in place and asking for our approval to execute the production installation process. 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.
Step 12:
This step allows you to configure the server. We tin can set the server in ii different modes. One is a standalone mode, and another 1 is cluster style. I don't want to get in every bit a cluster because I am installing MySQL for development purpose so that I am selecting Standalone MySQL server and click on Next.
Pace fourteen:
Choose the Development Computer selection from Config Blazon drop-downward. You can find the following controls similar TCP/IP, Port and X Protocol Port. If you wish to configure your port, you lot can change here itself and click on Next. For now, I am leaving as its default configuration.
Step xv:
It is prompting you to select the authentication method, leave it as the default recommended method and click on Adjacent.
Step xvi:
Here you tin set your MySQL root user password. If you wish to create a new user, you can click on Add User push nether MySQL user accounts section.
Step 17:
Upon clicking on Add together User button, y'all will become the user details popup which allows you to create a new user account. After creating the user click on Next.
Step xviii:
Leave the service details every bit default and click on Next.
Step 19:
Press Execute to utilise the configurations on the previous pace.
Step 20:
Upon execution, you tin encounter the beneath green coloured ticks on every configuration option and finally you will becomeStop button.
Click on Finish yous got your MySQL on your Windows x operating system.
Testing:
Search for MySQL in your taskbar search detail. There yous can come across all MySQL products which we installed and click on MySQL client; it will ask your MySQL countersign to login, later successful login yous could meet the MySQL prompt like beneath.
MySQL comes along with some default databases. We can see the databases by using show databases command.
We are completely washed with the installation process, and so now let's create a tabular array 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: carringtonthatted.blogspot.com
0 Response to "How To Setup Mysql Database In Windows 10"
Post a Comment