Scribd
Upload
78 views

MySQL Installation

The document provides a step-by-step guide to install MySQL on Windows 10. It details each step of downloading and running the MySQL installer, selecting installation options, configuring the server and authentication settings, and finally testing the installation. The steps include selecting the MySQL Community Server version, downloading the installer file, running the installer, choosing a custom or typical installation type, setting the root password and creating a new user, and verifying the installation by viewing sample databases.

Uploaded by

Josh Penascosas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
78 views

MySQL Installation

The document provides a step-by-step guide to install MySQL on Windows 10. It details each step of downloading and running the MySQL installer, selecting installation options, configuring the server and authentication settings, and finally testing the installation. The steps include selecting the MySQL Community Server version, downloading the installer file, running the installer, choosing a custom or typical installation type, setting the root password and creating a new user, and verifying the installation by viewing sample databases.

Uploaded by

Josh Penascosas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 22

Install Mysql on Windows 10 Step by Step 

Version Information: 

● Windows 10 Pro 
● Mysql Community Server 8.0.12 

Step 1: 

Download  the  latest  Mysql  Community  server  from  ​MySQL  official 


website​.  For  me,  it  is  8.0.12,  if  the  version  differs  you  no  problem  the 
installation steps will be the same. 

By  clicking  on  the  above  URL,  you  will  see  the  below  options.  Select  your 
operating  system  (Microsoft  Windows)  and  click on Go to Download Page. 
It will redirect you the actual download page for windows Mysql server. 

 
 

 
Step 2:  

It  will  show  you  ​Generally  Available  (GA)  Releases​.  Where  we  can see two 
different  installers,  one 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). 

 
 

 
Step 3: 

It  will  ask  your  MySQL  credentials  to  download  the  .msi  file.  If  you  have 
your  credentials,  you  can  log  in  or  else  if  you  wish  to  sign up now you can 
click on the green coloured signup button. 

If  you  are  not  interested  in  login  or  sign  up  for  now,  you  can  directly  go 
and  click  on  ​No  thanks,  just  start  my  download  option.  It  will  download 
selected MySQL for you on your local machine. 

 
 

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 5: 

This  window  configures  the  installer,  in  the  middle,  it  may  ask  you  for 
permissions  to  change your computer settings or firewall confirmation, you 
can accept and then it 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  5  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 ​Next​. 

 
 

 
Step 8: 

Based  on  your  Windows  configuration,  it  may  prompt  you  like  “One  or 
more  product  requirements  have  not  been  satisfied”.  You can just click on 
YES​. 

 
 

 
Step 9: 

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  product 
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 ​Next ​to configure the server. 

 
 

 
Step 12: 

This  step  allows  you  to  configure  the  server.  We  can  set  the  server  in  two 
different  modes.  One  is  a  standalone  mode,  and  another  one  is  cluster 
mode.  I  don’t  want  to  make  it  as  a  cluster  because  I  am  installing  MySQL 
for  development  purpose  so  that  I  am selecting ​Standalone MySQL server 
and click on ​Next​. 

 
 

 
Step 14: 

Choose  the  ​Development  Computer  option from Config Type drop-down. 


You  can  find  the  following  controls  like TCP/IP, Port and X Protocol Port. If 
you  wish  to  configure  your  port,  you  can  change  here  itself  and  click  on 
Next​. For now, I am leaving as its default configuration. 

 
 

 
Step 15: 

It  is  prompting  you  to  select  the  authentication  method,  leave  it  as  the 
default recommended method and click on ​Next​. 

 
 

 
Step 16: 

Here  you  can  set  your  MySQL  root  user  password.  If  you  wish  to  create  a 
new  user,  you  can  click  on  ​Add  User  button  under  MySQL  user  accounts 
section. 

 
 

 
Step 17: 

Upon  clicking  on  Add  User  button,  you  will  get  the  user  details  popup 
which  allows  you to create a new user account. After creating the user click 
on ​Next​. 

 
 

 
Step 18: 

Leave the service details as default and click on ​Next​. 

 
 

 
Step 19: 

Press ​Execute​ to apply the configurations on the previous step. 

 
 

 
Step 20: 

Upon  execution,  you  can  see  the  below  green  coloured  ticks  on  every 
configuration option and finally you will get ​Finish​ button. 

 
 

Click  on  ​Finish  you  got  your  MySQL  on  your  Windows  10  operating 
system. 

 
Testing: 

● Search for MySQL in your taskbar search item.  


● There  you  can  see  all  MySQL  products  which  we  installed  and  click 
on  MySQL  client;  it  will  ask  your  MySQL  password  to  login,  after 
successful login you could see the MySQL prompt like below. 

 
MySQL  comes  along  with  some  default  databases.  We  can  see  the 
databases by using ​show databases​ command. 

 
 
 
MySQL Create Table Syntax Example 
 
1. MySQL Create Table: 
A simple create table example without applying any keys and constraints. 

CREATE​ ​TABLE​ ​`​employee​`​ (​  


​`​id​`​ ​INT​(​11​), 
​`​firstname​`​ ​VARCHAR​(1 ​ 50​), 
​`​middlename​`​ ​VARCHAR​(​150​), 
​`​lastname​`​ ​VARCHAR​(​150​), 
​`​salary​`​ ​DOUBLE​, 
​`​designation​`​ ​VARCHAR​(​100​) 
)​ENGINE​=​InnoDB​; 
If  we  don’t  provide  any  constraints  to  the  columns  SQL  by  default  assigns 
DEFAULT NULL​ as default constraint. 

2. MySQL create table with the primary key: 

Designing  an  ​employee  table  with  id  as  primary  key  and  applying  default 
null constraint to middlenamee. 

CREATE​ ​TABLE​ ​`​employee​`​ (​  


​`​id​`​ ​INT​(​11​)​ ​NOT​ ​NULL​, 
​`​firstname​`​ ​VARCHAR​(1 ​ 50​)​ ​NOT​ ​NULL​, 
​`​middlename​`​ ​VARCHAR​(​150​)​ ​NULL​ ​DEFAULT​ ​NULL​, 
​`​lastname​`​ ​VARCHAR​(​150​)​ N ​ OT​ ​NULL​, 
​`​salary​`​ ​DOUBLE​ ​NOT​ ​NULL​, 
​`​designation​`​ ​VARCHAR​(​100​)​ ​NOT​ ​NULL​, 
​PRIMARY​ ​KEY​ ​(`​id​`) 
)​ENGINE​=​InnoDB​; 

 
2.1 Creating a primary key with default values: 

2.1.1 The default value as an ​AUTO_INCREMENT. 

CREATE​ ​TABLE​ ​`​employee​`​ (​  


​`​id​`​ ​INT​(​11​)​ ​NOT​ ​NULL​ ​AUTO_INCREMENT​, 
​`​firstname​`​ ​VARCHAR​(1 ​ 50​)​ ​NOT​ ​NULL​, 
​`​middlename​`​ ​VARCHAR​(​150​)​ ​NULL​ ​DEFAULT​ ​NULL​, 
​`​lastname​`​ ​VARCHAR​(​150​)​ N ​ OT​ ​NULL​, 
​`​salary​`​ ​DOUBLE​ ​NOT​ ​NULL​, 
​`​designation​`​ ​VARCHAR​(​100​)​ ​NOT​ ​NULL​, 
​PRIMARY​ ​KEY​ ​(`​id​`) 
)​ENGINE​=​InnoDB​; 
2.1.2 I am assigning ​999​ as a custom default value. 

CREATE​ ​TABLE​ ​`​employee​`​ (​  


​`​id​`​ ​INT​(​11​)​ ​NOT​ ​NULL​ ​DEFAULT​ ​'999'​, 
​`​firstname​`​ ​VARCHAR​(1 ​ 50​)​ ​NOT​ ​NULL​, 
​`​middlename​`​ ​VARCHAR​(​150​)​ ​NULL​ ​DEFAULT​ ​NULL​, 
​`​lastname​`​ ​VARCHAR​(​150​)​ N ​ OT​ ​NULL​, 
​`​salary​`​ ​DOUBLE​ ​NOT​ ​NULL​, 
​`​designation​`​ ​VARCHAR​(​100​)​ ​NOT​ ​NULL​, 
​PRIMARY​ ​KEY​ ​(`​id​`) 
)​ENGINE​=​InnoDB​; 

 
3. Verify: 

Once  you  create  a  table,  you  can  see  it  by  using  the  ​show  tables 
command like below. 

mysql​>​ ​show​ ​tables​; 


+​---------------+ 
|​ Tables_in_otp ​| 
+​---------------+ 
|​ employee ​| 
+​---------------+ 
1​ ​row​ ​in​ ​set​ ​(​0.00​ sec​) 
To  verify  the  structure  of  the  table  which  you  created,  you  can  use  the  ​describe 
command. 

mysql​>​ ​describe​ employee​; 


+​-------------+--------------+------+-----+---------+-------+ 
|​ Field ​|​ ​Type​ ​|​ ​Null​ ​|​ ​Key​ ​|​ ​Default​ ​|​ Extra ​| 
+​-------------+--------------+------+-----+---------+-------+ 
|​ id ​|​ ​int​(​11​)​ ​|​ ​NO​ ​|​ PRI ​|​ ​999​ ​|​ ​| 
|​ firstname ​|​ ​varchar​(​150​)​ ​|​ ​NO​ ​|​ ​|​ ​NULL​ ​|​ ​| 
|​ middlename ​|​ ​varchar​(​150​)​ ​|​ YES ​|​ ​|​ ​NULL​ ​|​ ​| 
|​ lastname ​|​ ​varchar​(​150​)​ ​|​ ​NO​ ​|​ ​|​ ​NULL​ ​|​ ​| 
|​ salary ​|​ ​double​ ​|​ ​NO​ ​|​ ​|​ ​NULL​ ​|​ ​| 
|​ designation ​|​ ​varchar​(​100​)​ ​|​ ​NO​ |​ ​ ​|​ ​NULL​ ​|​ ​| 
+​-------------+--------------+------+-----+---------+-------+ 
6​ ​rows​ ​in​ ​set​ ​(​0.04​ sec​) 
 

You might also like