How to install MySQL server on windows?

Last week I got an assignment where I need to install MySQL server on client’s machine, after checking the system requirements, I came to know that, the machine contains the 64 bit windows operating system. So I thought to download MySQL community server for windows 64 bit operating system, but I found that the website provides only 32 bit installer for windows, and for 64 bit operating system, the website provides the zip file for download. My client needs to manage the MySQL products by himself; he was expecting software where he can manage all MySQL products at one place, so we need MySQL installer in that machine. So I decided to install MySQL server on windows machine using MySQL installer web community. In this post, let me go through the step by step guide to install MySQL server on windows machine.

After reading this completely you can answer the following question:
  • How and where to get MySQL community edition?
  • How to install MySQL server on windows?
  • How to configure MySQL server using windows installer?
  • How to create and assign roles to user using MySQL installer?
  • How to activate MySQL log files on production machine?

MySQL community server:


Oracle provides two editions of MySQL server, enterprise edition and community edition, in our post we are using MySQL community server you can get the MySQL community server from the following link, MySQL community edition.

After reading the features of the MySQL community edition, there is a link at the bottom, by clicking on that link, you will get all the products available from MySQL, click on the MySQL community server and you will get the link for MySQL community server installer.

In my case I needed web installer, since I was trying to install MySQL community server on 64 bit windows operating system, if you face similar situation you can get the MySQL web server community from clicking on the following link MySQL web community server, click on the first result, it will directly take you to the web community installer page. Note that for running MySQL web installer you need online connection and MySQL installer is 32 bit, but will install both 32 bit and 64 bit binaries.















Installing MySQL server on Windows machine:


After complete the first step, you will get the MySQL installer in your system, the next step will be installing the MySQL server on windows machine using windows installer. Right click on the file you recently get and click on install, see the following image for detail:

MySQL installer web community
MySQL installer web community

License Agreement:


Now the MySQL installer will start running, at the first step it will display the license agreement, after completely reading the agreement click on Next button present at the bottom of the page.

MySQL License Agreement
MYSQL LICENSE AGREEMENT


Choosing the setup type:


After clicking on the Next button, you will get the choosing set up type window, where you will different set up types provided by MySQL. By selecting this setup type you are choosing which MySQL products will be installed on your system. 

The setup type window contains the following types:

Developer: Developer is the default setup type. Choosing this type will install all products needed to develop applications with MySQL.

Server only: Choosing this type will install only the MySQL community server.

Client only: Choosing this type will install only the MySQL client products, such as MySQL Workbench. This setup type does not include the MySQL community server.

Full: This setup type will install all available MySQL products such as server, client products, workbench, etc.

Custom: By choosing this setup type you can manually select the MySQL products to install, and optionally configure custom MySQL data and installation paths.

I recommend you to choose the Custom type for beginners so that you can get an idea of all the products available from MySQL, by mistake if you not selecting some products for installation at this stage, no problem you can add the required product later using MySQL installer.

The choosing setup type window may look like this:

Choosing setup type
CHOOSING SETUP TYPE


Selecting products and features:


After choosing the setup type and clicking on the next button, product and features selection windows will be opened, depends upon the setup type MySQL products will be displayed here for selection, if you clicked Custom setup type in previous window, all the MySQL products will be displayed in this window, you can select the required MySQL products for installation, even if you not selected some required products or features or selected some extra products you can add or remove those products later. After selecting the required products and features click on the Next button.

The selecting products and features window may look like as follows:

SELECT PRODUCTS AND FEATURES
SELECT PRODUCTS AND FEATURES


Checking requirements:


Once the products and features are selected, the MySQL installer will check for pre-requisites required for the selected products to install on windows machine. In check requirement window you can see tab called status, it contains the value Manual for some requirements and remaining requirements it contains the value it displays Blank space.  For MySQL installer will automatically install the products for which the status showing Blank space, but for products in which the status showing Manual you have to manually install that particular products. After manually installing the required products, click on the Execute button, now the MySQL installer will start installing the remaining products. The checking requirement window may look like as follows:

Check requirements
CHECK REQUIREMENTS

During this process new pop-up windows may displayed where you have to choose Install button to install those particular products, the pop-up windows may look like as follows:

Installing MySQL external requirements
INSTALLING REQUIREMENTS

After clicking on Next button, the MySQL installer will open the installation window.

MySQL Installation:


MySQL installer will display the list of all the selected products to be installed on the windows machine. At the bottom of the windows, you will see a button called Execute by clicking on that button, the MySQL installer will start installing the selected products, and you can view the progress and status of the installation process. After all the selected components are installed on your machine, the MySQL installer will display a new window where you can configure the recently installed MySQL products. The installation window may look like as follows:

Installation of MySQL
INSTALLING MYSQL


Product configuration:


Product configuration windows will provide an overview of the products which you are going to configure in the next window and the configuration status. After checking the product and configuration status, click on the Next button to open the configuration window. The product configuration window may look like as follows:

Product configuration
PRODUCT CONFIGURATION

Configuration type and Connectivity:


The type and networking window allows you to choose the configuration type and connectivity. The type and networking window may look like as follows:

Type and networking
TYPE AND NETWORKING


Server configuration type:


Configuration type defines the amount of system memory that will be assigned your MySQL server instance. There are three different configuration types available in MySQL community server, let’s take a look at those types:

Development Machine: A machine that will host many other applications. This option configures MySQL to use the least amount of memory. If you want to install MySQL on your laptop or desktop use this option.

Server Machine: Several other applications will be running on this machine, such as a web server. This option configures MySQL to use a medium amount of memory.

Dedicated Machine: Choose this option if you need a dedicated machine for MySQL database server. No other servers, such as web servers will be run on this machine. By choosing this option MySQL will make use of all available memory.

Server configuration type
SERVER CONFIGURATION TYPE


Connectivity:


After choosing the configuration type, you have to choose the connectivity option. Connectivity options lets you control how the connection to MySQL is made. Connectivity options include:
TCP/IP: If you need to access your database over internet choose this option, without choosing the option only localhost connections are allowed. You have to define the Port Number and click on the check box to open the firewall port for network access. The default port number for MySQL instance is 3306.

Named Pipe: Enable and define the pipe name, similar to using the --enable-named-pipe option.

Shared Memory: Enable and then define the memory name, similar to using the --shared-memory option.

By selecting Advanced Configuration box will allow you to configure the logging options including setting up custom file paths for the error log, general log, slow query log (including the configuration of seconds it requires to execute a query), and the binary log.

After choosing appropriate options for type and networking, the window may look like as follows:

Type and networking
TYPE AND NETWORKING


Accounts and Roles:


After choosing the MySQL server configuration type and connectivity options, the next window allows you to set root account password and allows you to create MySQL user accounts.

Set the root password, the password strength will be shown at bottom of the text box. Click on Add User button to add new user and assign roles to recently created user.

The Accounts and Roles window may look as follows:

Accounts and roles
ACCOUNTS AND ROLES

The Add User window may look like as follows:

Adding new user
ADD NEW USER WINDOW

The available user roles are given below:

User roles
USER ROLES

After setting the root password and creating new user (optional) click on Next button.

Windows Service:


The windows service window will allows you to configure the windows service options. In this window you have to setup the windows service details. You have to provide a unique name for each server instances. The default windows service name is MYSQL57 for MySQL community server 5.7.1. If you need to run MySQL server under a given user account, you can choose the Custom User option. Keep in mind that, if you need to choose Custom User option, the custom user must have privileges to log on to Microsoft Windows as a service. After choosing the required options click on Next button.

The windows service option may look like as follows:

Windows service
WINDOWS SERVICE

Advanced Option:

In advanced option, you can configure the custom path for MySQL error log, general log, slow query log and binary log.  After selecting the required logging options click on Next button.

The advanced option window may look like as follows:

Advanced options
ADVANCED OPTIONS

Apply server configuration:


By clicking on the execute button on all the configuration will be applied to the MySQL community server installed on your windows machine. The icon for each step toggles from white to green on success, or the process stops on failure. The Log tab used to view the log. The apply server configuration window may look like as follows:

Apply server configuration
APPLY SERVER CONFIGURATION


Installation complete:


Once the configurations are applied to the server and click on the next button the installation complete window will be opened. Now the MySQL community server is installed on your windows computer and MySQL installer is added to your start menu.

Installation completed
INSTALLATION COMPLETE

I hope this post will help you to install MySQL community server on your windows machine. If you have any queries or want to share your thoughts, use the comments section. If you like this post, kindly share it with your friends.

89 comments:

  1. Cool stuff you have and you keep overhaul every one of us. generate ideas

    ReplyDelete
  2. Crack software! This website content is more helpful. And thanks for share the information.

    ReplyDelete
  3. Adobe Flash Builder Crack Premium Full Serial With Keygen Abobe Flash Builder 4.7 top quality Crack is just one of those massive players at the category of Flash IDEs, offering a professional progress environment suggested in making remarkable Software and re-creations for its internet adaptive or touch-empowered gadgets, as an instance, high-level cellphones and tablet computers.New Crack

    ReplyDelete
  4. https://thinkcrack.com/adobe-photoshop-cc-serial-key-cracked/
    Adobe Photoshop CC Crack is created by adobe system. It is a raster-based software, which depends on pixels. It was established in 1988 by Thomas and Jhon Knoll. Its name shows that this software is related to photo. At the starting, it was built for in which we can edit photos.

    ReplyDelete
  5. https://crackeypc.com/360-total-security-premium-crack/
    360 Total Security Crack is a useful place where you can easily find Activators, Patch, Full version software Free Download, License key, serial key, keygen, Activation Key and Torrents. Get all of these by easily just on a single click.

    ReplyDelete
  6. FL Studio Crack
    FL Studio Crack is a very well software for music production. Further, If you use the Interface software for music production, which is very simple and effective to use. And this will help in your work becomes much well organized. Moreover, It will also offer an integrated developed environment for you.

    ReplyDelete
  7. wow, great, I was wondering how to cure acne naturally. and found your site by google, learned a lot, now i’m a bit clear. I’ve bookmark your site and also add rss. keep us updated. stop code

    ReplyDelete
  8. Data scientists and analysts have a substantial career growth and there prevails a huge gap between talent and hiring, meaning that there are more job opportunities than the qualified data scientists to occupy them. artificial intelligence course in hyderabad

    ReplyDelete

  9. Ccleaner-Pro license key is a useful utility for computers with MS Windows. That cleans out all those junk that accumulates over time like broken shortcuts, temporary files, and many other problems. It is the best tool for cleaning your computer. As It makes your system work smoothly and fast. It also secures your system and protects your privacy.
    IDM Crack Setup

    ReplyDelete
  10. Pcgamesfully
    Full Version Pc Game Free Download Fully

    ReplyDelete
  11. Keystool
    Crack Software Download Free Here

    ReplyDelete
  12. Chprokey
    Full Version Crack Software Fully Download Free

    ReplyDelete

  13. 4k-video-downloader-crackis allows you to download high-quality videos, playlists, channels, and subtitles from YouTube, Facebook, Vimeo, and other video websites. Enjoy your videos anywhere, at any time, and, of course, even offline. The download is simple and direct.
    Free Pro Keys

    ReplyDelete
  14. The normal database software like Oracle and SQL aren't enough to process this enormous amount of data. Hence the terms 'Big data' and 'Data science' were coined. data science course syllabus

    ReplyDelete
  15. Thank you for some other informative site.
    where else may just I am getting that kind of information written in such a perfect way?
    I have a challenge that I am just now operating on, and I have been on the glance out for such info.
    wondershare tunesgo crack
    7 data recovery crack
    malwarebytes anti malware crack
    advanced systemcare pro crack serial key

    ReplyDelete
  16. This is my first time i visit here. I found so many entertaining stuff in your blog, especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the leisure here! Keep up the good work. I have been meaning to write something like this on my website and you have given me an idea.

    data science course in India

    ReplyDelete
  17. This site is very fantastic. Very awesome post. In first time I am visit your site, and your site change my day. Thanks for sharing.
    Cycling 74 Max Crack

    ReplyDelete
  18. Thank you so much for sharing such amazing information. Your website is very cool. I am very impressed by the details that you have on your site. I am Bookmarked this website. keep it up and again thanks.
    KeyShot Pro Crack

    ReplyDelete
  19. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
    Artificial Intelligence Course

    ReplyDelete
  20. Thanks for sharing this piece of information. I really enjoyed it. keep up the good work and all the very best of luck! I like this post
    Website :- Gas and Electric Geyser near me

    ReplyDelete
  21. Thanks for sharing this piece of information. I really enjoyed it. keep up the good work and all the very best of luck!
    avast antivirus crack

    ReplyDelete
  22. I don t have the time at the moment to fully read your site but I have bookmarked it and also add your RSS feeds. I will be back in a day or two. thanks for a great site.
    Best Data Science Courses in Hyderabad

    ReplyDelete
  23. I don t have the time at the moment to fully read your site but I have bookmarked it and also add your RSS feeds. I will be back in a day or two. thanks for a great site.loving kindness meditation script

    ReplyDelete
  24. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking.mindfulness meditation scripts

    ReplyDelete
  25. https://activatorskey.com/sketch-crack-torrent-full/
    Sketch Crack is a strong graphic design tool. That is used in web design and interact with multimedia folders. Though, Sketch is commonly simple to use.

    ReplyDelete
  26. https://boxcracked.com/sony-vegas-pro-18-crack/
    Sony Vegas Pro Cracked Guru has advanced editing programs for editing. This system integrates a fresh”Edit” style which lets an individual briefly trim on the video as a way to remove or add certain pictures

    ReplyDelete
  27. https://www.thecrackbox.com/one-click-root-2020-crack-apk-free-download/
    One Click Root 2020 Crack can be really a tool that enables one to wholly scroll and down your mobile’s scrollbars with a single bit of this monitor. Situated at the top left corner, once you first visit the cover of the pub, and also at the top right corner, then you first goto the close of the scroll bar

    ReplyDelete
  28. ABBYY FineReader 15 Crack Free Download
    ABBYY FineReader 15 Crack is a digital file reader tool. It helps you to create your digital tool that provides a good set of text. It allows you to manage all PDFs, allowing the consumer to meet the same user requirements

    ReplyDelete
  29. DraftSight Crack Latest Version
    DraftSight Crack is a professional application that produces a variety of designs for drawing. The scales are available in a different format. With the help of this, most of the professional people draw the sketch of building and home

    ReplyDelete
  30. ArcGIS Crack Full Version Download
    ArcGIS Crack is a geological data operation software. This software works with charts, maps, and much geographical data. This assists the user to produce and manage the geographic plans and maps. The users can also incorporate geographic report by it

    ReplyDelete
  31. Camtasia Studio Crack Latest Version
    Camtasia Studio Crack is an outstanding video recorder program to earn video lessons. Therefore it is easy to use tools that help you to make, edit, and also cut the video. While it also supports all kinds of format. It is the best sound and film video shifting

    ReplyDelete
  32. WavePad Sound Editor Crack Full Version Download
    WavePad Sound Editor Crack is a good music editing application that has a standard interface with simple and easy to use and understand functions. Developed by NCH Software

    ReplyDelete
  33. Thank you for sharing such a useful post. Very Interesting Post! I regularly follow this kind of Blog.
    CCC Online Test

    ReplyDelete
  34. Hello! This post couldn’t be written any better! Reading through this post reminds
    me of my good old room mate! He always kept chatting
    about this. I will forward this write-up to him.
    Pretty sure he will have a good read. Thank you for
    sharing!
    hard disk sentinel pro crack

    ReplyDelete
  35. This is also a very good post which I really enjoy reading. It is not everyday that I have the possibility to see something like this. Ramen deuren

    ReplyDelete
  36. Great article Lot's of information to Read...Great Man Keep Posting and update to People..Thanks Ramen en deuren Leuven

    ReplyDelete
  37. good work and thanks for share my link Latest Version Of registration code 100% working Crack
    Sketch Crack

    ReplyDelete
  38. Very informative and It was an awesome post...... R-Studio Crack

    ReplyDelete
  39. Looking great work dear, I really appreciated to you on this quality work. Nice post!! these tips may help me for future. Easeus Todo Backup Crack/a>

    ReplyDelete
  40. Very informative and It was an awesome post...... PUBG PC Crack

    ReplyDelete
  41. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    data science courses in noida

    ReplyDelete









  42. I am very impressed with your post because this post is very beneficial for me and provide a new knowledge to me
    https://cracksumo.com/coreldraw-graphics-suite-crack/


    ReplyDelete









  43. I am very impressed with your post because this post is very beneficial for me and provide a new knowledge to me
    https://cracksumo.com/coreldraw-graphics-suite-crack/


    ReplyDelete



  44. I really like your post because it helps me a lot and gives me a new perspectiv
    https://crackdew.com/lightworks-pro-crack/

    ReplyDelete
  45. nordvpn-crack-keygen For home windows can browse all the matters easily and securely. through Nord VPN Activation Key based totally, the customers also can get get right of entry to to their bank element with none issue of hesitation. consequently the users get such privacy and protection that no person can take a look at our network connection and take a look at our on-line surfing. So, it is clear that it's miles a defend for our system towards the 0.33 birthday party. gives get right of entry to to all the websites we wish to apply privately.

    ReplyDelete




  46. I really like your post because it helps me a lot and gives me a new perspective
    https://cracksumo.com/avast-internet-security-crack/

    ReplyDelete




  47. I really like your post because it helps me a lot and gives me a new perspective
    https://cracksumo.com/avast-internet-security-crack/

    ReplyDelete
  48. Nice Work
    https://mobisoft.info/4k-video-downloader/

    ReplyDelete
  49. TOTAL Video Converter Crack is an extremely powerful and complete video converter that converts all videos and audio data to MP4, AVI, iPhone, iPad, Mobile, PSP, DVD … and records videos in DVD, AVCHD, Blu-ray and more. So Total Video Converter is an extremely powerful and complete conversion software that supports almost all video and audio formats.
    Sylenth1 Crack
    Guitar Pro Crack Download
    KeyShot Crack Free Download

    ReplyDelete
  50. AnyDesk Crack is the Remote Desktop that is famous and brand new software, especially design for new viewing graphical individual interfaces. It’s secure, lightweight, versatile, and reviewed into a file that is 1MB. No chances administrative installation is required.
    CCleaner Professional Crack
    Gangstar Vegas Mod APK
    Valhalla Shimmer Crack

    ReplyDelete
  51. eM Client Crack is an email client, designed for Windows. The tool comes with interesting features, such as calendars, contacts, and tasks, and it can be easily handled by users of any level of experience.
    FL Studio Crack Key
    Tunnelbear VPN Crack
    Movavi Screen Recorder Crack
    Miracle Box Serial Key With Crack

    ReplyDelete
  52. Iperius Backup Crack you can also set the destination folder and some other parameters. There are two backup methods offered by the first being the Changed Block Tracking method and the other the Standard method.
    VSDC Video Editor Crack
    SmartDraw Crack
    HD Tune Pro Crack

    ReplyDelete
  53. Spotify Premium Crack is a full featured audio streaming service. Provides music streaming service for streaming music from websites through many official. Plus, it serves as a quick tool for consuming podcasts.
    Stardock Fences Crack
    DU Meter Crack
    Windows KMS Activator Cracked

    ReplyDelete
  54. It is very interesting, you are an experienced blogger. I have added your feed and I hope to continue searching.
    great posts. Also, I have shared your site on social media!

    ipvanish vpn crack

    ReplyDelete
  55. Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more. Primavera Course in Chennai | Primavera online course

    ReplyDelete
  56. I have a similar interest this is my page read everything carefully and let me know what you think. beginner unreal engine courses

    ReplyDelete
  57. Keyword Researcher Pro Crack

    Thank You For Sharing Such A Valuable Information.

    ReplyDelete
  58. IOBIT Driver Booster Crack is excellent software that helps you find outdated drivers and update them to the latest version. With nearly 1 million driver databases, you can easily find outdated software and update it instantly and easily. With just one click you can see all the software that needs updating. The IOBIT Driver Booster Pro key provides detailed information on devices, game components, vendors, vendors, and versions to give you the best possible performance. Driver Booster can automatically search, download and install the necessary files. You can also create a restore point in case your drivers get corrupted due to driver update failure.

    ReplyDelete