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.

70 comments:

  1. Replies
    1. Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important. Project Center in Chennai It’s what organizations do with the data that matters. Big data can be analyzed for insights that lead to better decisions and strategic business moves.

      Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.
      Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai


      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. IEEE final year projects on machine learning In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

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

    ReplyDelete
  4. Great Article. Thank you for sharing! Really an awesome post for every one.

    IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
    Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

    ReplyDelete
  5. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. windows iso

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

    ReplyDelete
  7. https://thepcgameshere.com/
    Here at thepcgames.com a huge collection of multiple action,adventure and many more games are waiting for game lovers. You will found evey game here that you want.

    ReplyDelete
  8. 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
  9. I'm impressed, I must say. Very rarely do I come across a blog thats both informative and entertaining, and let me tell you, you ve hit the nail on the head. Your blog is important.. https://serverbrowse.com/

    ReplyDelete
  10. https://autocracked.org/save-wizard-torrent-crack/
    Save Wizard Crack is a complete, master copy and good slicker code. That is used in the play station store. The save wizard is discovered in 2017. Now it is play slickers in hundred of the games. For example, Max gold keys used for borderland 3.Save wizards for PS4 play about affairs for anyone.

    ReplyDelete
  11. https://approvedcrack.com/pubg-for-pc-crack-full-torrent/
    PUBG Pc Crack it stands for PlayerUnknowns Battlegrounds (PUBG). PUBG is a type of software. PUBG is most widely too used entire the world for specific purposes. PUBG allows you an online multiplayer battle royale game. PUBG game is based on the previous model. It supports to unreal engine. It is the genre of battle royale. It works with multiplayer.

    ReplyDelete
  12. 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
  13. https://vikipc.com/sketchup-pro-2020-crack/
    SketchUp Pro Crack can use different technologies to make their businesses the most profitable, and also you can use various educational purposes. Many applications you can use to design your work, to set your wallpapers, to set background. Now technologies are a necessary part of our life.

    ReplyDelete
  14. 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
  15. https://crackedos.com/cubase-pro-crack-torrent/
    Cubase Pro Crack is many advanced technologies that can support you in many missions for the security of your future you can easily implement your ideas. You can easily bring innovations and can introduce new elements in new ways. You can easily get new opportunities and will be able to face new challenges.

    ReplyDelete
  16. https://greencracks.com/fl-studio-torrent-full-crack-download/
    FL Studio Full Crack (Fruity Loops) basically a digital audio workstation flourished by the Belgian company Image-Line. As for the first version of Fruity Loops which (1.0.0) developed by Didier Dambrian and released in December 1997 and further enhanced in 1998 to make sure it four channelled “MIDI Drum Machine” and undergone a number of major technical updates since its inception and become popular worldwide.

    ReplyDelete
  17. 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
  18. 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
  19. Thanks a lot for sharing such a good source with all, i appreciate your efforts taken for the same. I found this worth sharing and must share this with all.


    Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery




    ReplyDelete
  20. Great Article
    Cloud Computing Projects


    Networking Projects

    Final Year Projects for CSE


    JavaScript Training in Chennai

    JavaScript Training in Chennai

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete
  21. 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
  22. This is my first visit to your blog! We are a team of volunteers and new
    initiatives in the same niche. Blog gave us useful information to work. You
    have done an amazing job!

    artificial intelligence training in Bangalore

    ReplyDelete

  23. 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
  24. Pcgamesfully
    Full Version Pc Game Free Download Fully

    ReplyDelete
  25. Keystool
    Crack Software Download Free Here

    ReplyDelete
  26. Chprokey
    Full Version Crack Software Fully Download Free

    ReplyDelete
  27. Like!! I blog frequently and I really thank you for your content. The article has truly peaked my interest.
    the post was excellent and good.we made the most of the article,thank you
    Naagin 5

    ReplyDelete

  28. 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
  29. It is one of the fields that find applications across various business, including communication, finance, manufacturing, healthcare, retail etc. data science course syllabus

    ReplyDelete
  30. 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