Learn How to Install MySQL Database Server on Windows Operating System

Learn How to Install MySQL Database Server on Windows Operating System


Before we start learning SQL, we will require MySQL database server installed on our local computer. So that we can practically write and execute the SQL commands. In this lecture, we will learn how to download and install MySQL database server on a computer running windows operating system. In my case, I’m using Windows 7 64 bit operating system. You may be using a different version of windows like Windows 8 or Windows 10. Whichever windows version you may be using the installation steps will be similar. Open your web browser and enter mysql.com This is the official website of MySQL which is acquired by Oracle Corporation in 2010. Under the downloads menu, you will find “MySQL Community Edition (GPL)” title followed by the download page link. On this download page there are several products by MySQL but we are only interested in downloading “MySQL Community Server”. So Go ahead and click download link. On this page, From “select platform” option, select “Microsoft Windows” and under “Recommended Download”, you will find MySQL Installer for Windows. There are also zip archives available for download. We will download “MySQL Installer MSI”. Since, there is no 64 bit installer available, though I’m using windows 7 64bit operating system, I’ll go ahead and download 32bit installer. Again here you can choose either MSI file downloader or directly download the MSI file installer. I’ll download the MSI installer by using the given link. If you want you can signup for an Oracle Web account. This is an optional step, so I’ll the skip sign up by clicking “No thanks, just start my download”, and save the file to my computer. To save some time I already have downloaded the file on my desktop. So lets start with the installation. Double click the installer to start the installation. The installer will extract the files in the background and will launch the installation in a couple of minutes or less. OK! here we’ve the installation window. You must accept the license terms in order to install and use the MySQL server on your computer. Select “I accept the license terms” check-box and click next. In the setup type choose “Custom” so that we can customize the products and path for the installation. Click Next. Here in left side column we have available products for the installation. Click the plus sign in-front of “MySQL Servers”, “MySQL Server” Under and “MySQL Server 5.7”, Choose the appropriate MySQL server for you computer. If you are using 32bit operating system then select “MySQL Server 5.7.10 – X86” version and if you are using 64bit operating system select “MySQL Server 5.7.10 – X64”. In my case I’m using 64bit operating so I’ll select “X64” version. Once you select the MySQL Server, make sure you click this green arrow, which will include selected software in the installation. Follow the same steps for “Applications” and MySQL Workbench. I’ll again choose 64bit version. Don’t worry with the rest of the applications. in this course will only use, mysql server command line tool and mysql workbench. Click next. Since I already have previously installed MySQL server, so the path already exists. So I’ll click next. Now, Depending upon pre-installed software, you may or may not have to install other essential softwares like, here in my case I need to install Microsoft Visual C++ 2013 Run-time before starting the installation. Select the software and click “execute button”. It will launch Microsoft Visual C++ 2013 redistributable setup. Click agree and install to install the required software. close to finish the installation and click next. Here the setup is ready to install the following selected products. Click “execute” button. It will take a couple of minutes or less to copy the files on your computer. OK! The installation copied all the files necessary for the installation. click next. Now, its ready to configure. Click next. In “config type” choose “Development Machine”. By default mysql will choose the available port “3306”, If you see a yellow mark over here, it means the port is already in use. you can change the port number to other than 3306. All the other options are fine. Click next. Under “Accounts and Roles” window, you can set password for your default username that is “root”. I’ll set a password for my installation here. Retype the password. Make sure you remember the password for your root user or note it down somewhere. We’ll need this password while logging in to mysql database server. Click next. In “windows service” window all the default options are fine. click next. Apply server configuration setting by clicking “Execute” button. It will take a minute or less to apply the settings. Click finish to complete the installation. Click next. Uncheck Start MySQL workbench after setup option and click finish. Here We successfully completed the installation of MySQL database server on our computer. Now, Open start menu, here you will find the mysql command line client. If you don’t find the shortcut icon here, Go to under “all programs”, Under MySQL, MySQL Server 5.7, MySQL Server 5.7 command line client. Enter the password you choose while the installation. If you successfully logged into MySQL you will get this mysql prompt, And now you are ready to start learning SQL. You can also click and open MySQL workbench the same way. “Start Menu”, “All Programs”, “MySQL”, MySQL workbench. We will learn more about MySQL workbench later in this course. One more thing before we stop here. In windows by default, command line have small window and it’s difficult be maximize it to full screen. To adjust the width and height of command line window, right click on the top of the window and select properties. Under layout you can adjust the window size according to your needs, from this “Window Size” option. From “Font” tab, You can also change the colors and fonts for your command line tool. Play around with these settings and make sure you have bigger window with color and fonts of your choice. In next section we will start learning SQL with practical examples.

56 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *