Installing MySQL Community Server on Windows

Submitted by sneha on Fri, 06/06/2014 - 23:40

Steps verified for versions: 5.6.19. Steps last verified on: 7/JUN/2014.

We can easily install the free MySQL community server on Windows following the below simple steps:

Step 1: Download MySQL community server latest version. Current download page link is http://dev.mysql.com/downloads/mysql.

Step 2: Select the platform as Microsoft Windows, click download for Windows (x86, 64 bit) MySQL Installer MSI, then click download for Windows (x86, 32-bit), MSI Installer (community, non web, version with 200+ MB), and finally in the next page click ‘No thanks, just start my download’ at the bottom to start download immediately without logging in.

Note: There is currently only a 32 bit version, but it will work on both 32-bit and 64-bit machines.

Step 3: Once downloaded, double click the MSI installer to start the installation.

Step 4: In the Welcome screen, click ‘Install MySQL Products’.

Step 5: Accept the license and click next.

Step 6: Optionally check for updates to see if there are any latest updates or skip the check for updates and click next.

Step 7: Select the Full installation and click next. This installs all of the products available in this catalog including MySQL Server, MySQL Workbench, MySQL Connectors, documentation, samples and examples and much more.

Step 8: Verify if all prerequisites are met and click next.

Step 9: Verify the tools to be installed (screenshot below) and click Execute.

Step 10: Once the above installation is done, click next twice to configure the MySQL installation. Select the config type as ‘Development Machine’, leave others and default, but note down the port used. Usually it will be 3306, but if that is in use, then the next available one (e.g. 3307) will be used.

Step 11: Give a username and password and remember it. Click Next.

Step 12: Is it preferred to unselect the ‘Start MySQL at system startup option’ if running MySQL is not the primary function of this machine and if you will be using this machine for other development activities also. Click Next and MySQL Server will be configured accordingly.

Step 13: Click next to configure samples and examples.

Step 14: Before you click finish, it is good to copy the MySQL log to clipboard using the button provided and save it somewhere.

Step 15: Click finish with Start MySQL workbench option selected.

Post installation, you can start or stop MySQL servers from Windows services. Also, you can login and run queries using the workbench.

Quick Notes Finder Tags

Activities (1) advanced java (1) agile (3) App Servers (6) archived notes (2) Arrays (1) Best Practices (12) Best Practices (Design) (3) Best Practices (Java) (7) Best Practices (Java EE) (1) BigData (3) Chars & Encodings (6) coding problems (2) Collections (15) contests (3) Core Java (All) (55) course plan (2) Database (12) Design patterns (8) dev tools (3) downloads (2) eclipse (9) Essentials (1) examples (14) Exception (1) Exceptions (4) Exercise (1) exercises (6) Getting Started (18) Groovy (2) hadoop (4) hibernate (77) hibernate interview questions (6) History (1) Hot book (5) http monitoring (2) Inheritance (4) intellij (1) java 8 notes (4) Java 9 (1) Java Concepts (7) Java Core (9) java ee exercises (1) java ee interview questions (2) Java Elements (16) Java Environment (1) Java Features (4) java interview points (4) java interview questions (4) javajee initiatives (1) javajee thoughts (3) Java Performance (6) Java Programmer 1 (11) Java Programmer 2 (7) Javascript Frameworks (1) Java SE Professional (1) JPA 1 - Module (6) JPA 1 - Modules (1) JSP (1) Legacy Java (1) linked list (3) maven (1) Multithreading (16) NFR (1) No SQL (1) Object Oriented (9) OCPJP (4) OCPWCD (1) OOAD (3) Operators (4) Overloading (2) Overriding (2) Overviews (1) policies (1) programming (1) Quartz Scheduler (1) Quizzes (17) RabbitMQ (1) references (2) restful web service (3) Searching (1) security (10) Servlets (8) Servlets and JSP (31) Site Usage Guidelines (1) Sorting (1) source code management (1) spring (4) spring boot (3) Spring Examples (1) Spring Features (1) spring jpa (1) Stack (1) Streams & IO (3) Strings (11) SW Developer Tools (2) testing (1) troubleshooting (1) user interface (1) vxml (8) web services (1) Web Technologies (1) Web Technology Books (1) youtube (1)