MySQL is one of the largest and most frequently used relational database management software in the IT world. As it is easy to install and maintain, beginners love to work on MySQL. As a fresher or non-technical fellow, there isn’t much to know before working with MySQL. With minimum to medium range knowledge on databases, tables, and storage strategies, one can pace up and become a pro using MySQL. In this article, we will go through all the steps related to MySQL Installation.
- MySQL Software
- MS .NET Framework (latest version preferred)
- MS Visual C++ Redistributable for Visual Studio 2021
- RAM 4 GB
How to download MySQL
Setting up MySQL takes two significant steps, i.e., downloading and installing, which further contain sub-steps in each of them.
- Download the MySQL community server edition software from the company’s official website. You can select an operating system, such as Windows, from such a menu.
- In the MySQL community server, there are two options. Based on your internet speed and strength, you can download either one of them from the below options:
A)Windows (x86–32 bit) MSI Installer 18.6M storage
B) Windows (x86–32 bit) MSI Installer 398.9M storage
- Once the downloading is done, a zip file gets uploaded into the system. Unzip it by clicking on MSI installer. exe file.
- When a file is unzipped, the MySQL installer asks about choosing a setup type. Out of five options provided, select Full. This will install all the MySQL products and features, then click on next.
- Then, the following screen displays the features that may fail to install. By clicking the execute button, a dialogue box appears asking to confirm the above features to install. Click on Yes. Then it displays the list of features and products that are missed out and need to be installed.
- Once you see the list displayed, click on execute. Then after the required features are installed, the status shows as complete. Once all the listed features are completed, click on next.
- The next page talks about the product configuration and router setup. There is nothing much to do here; click on the Next button.
- This directs to the next page called high availability, provided with two options. Select the first option called Standalone MySQL Server/Classic MySQL Replication and click on next.
- The next page talks about the type and networking here Config Type, Connectivity, Port Number select as development computer, TCP/IP, 3306 respectively and clicks on next.
- Then comes the authentication method page, where you need to select the first option and click on next—followed with the account and roles page requires you to fill in MySQL root password and confirm the same. Click on next.
- Followed with window service page, let everything be as is, and click on next. On the next page, a default configuration gets selected, and if that is ok click on execute. Later, when all the required configurations are completed, click on the finish button. You are almost ready to start your server with a few more steps ahead.
- Then followed by product and MySQL router configuration pages. Just go through them and click on the next and finish buttons.
- Then comes the connect to server page, where you need to enter that ROOT password you created before then click on check. Followed by apply configuration screen, click on execute.
- Once the configuration is completed, click on finish. Here comes the last page, called the complete installation page, then click on a finish button.
Verify MySQL installation
Here is a way to verify your MySQL installation and test to check its working and other features.
Go to MySQL command-line client and enter the password (if any). You are connected to the MySQL server and can run and execute your commands and get your required outputs.
Creation of MySQL Database with phpMyAdmin
- A well-functioning MySQL server connection is required with a user login to create Databases.
- An instance phpMyAdmin is required appropriately connected to the MySQL server. When the phpMyAdmin is ready, creating a database is only minutes far.
Follow the below steps to create a database through phpMyAdmin
- Start with browsing the phpMyAdmin URL with your root password or login credentials.
- Once you have logged in, search for the databases button on the top of the screen. Click on that. Then you will get three boxes under create database. In the first box, give a name for your database and click on create.
- When the database is created, it appears on the left side of the screen with your given name. Then need to set up user login by clicking on users, present on the top of the screen. Click on add user below to add a new login.
- Then comes the login information screen, where you need to fill in the username, localhost, and password details; click on generate to complete the login.
- Followed with global permissions page. Global permissions are something that is given to specific users. But on a general basis, do not change anything in global permissions unless you know what to do. Then click on add user.
- A list appears in which if you already created a user, it gets displayed. Check on the user you created and click on edit privileges.
- Then click on database-specific privileges and type your database name and click on GO.
- Then check all the below privileges: Select, Insert, Update, Delete, Create, Alter, Index, Drop, Create Temporary Tables, Lock Tables, as these are recommended and mandatory ones in any database, and click on GO.
- Then, all your privileges are displayed on the screen, and your database is all set to work. Once log out by clicking the icon on the left top of the screen and logging back, start working on your database and explore all the SQL commands.
Thus, the downloading and installation of MySQL server is completed.
I hope you find it helpful.