MySQL Databases – MySQL Database and 13 steps to Install MySQL Server

MySQL Databases – MySQL Database and 13 Steps to Install MySQL Server

MySQL is an acronym for My Structured Query Language. And it is a Relational database management system. Its source code is freely available and can be distributed to its users anytime, anywhere. So that is a brief information about Mysql.

Now Database, when you hear the word base, What comes to your mind, is’ a space occupied by something. It can be a house, a cubicle, a hut, and so on. Therefore database can be said to be a place where data is stored, or a collection of data is kept. By now, you should know what we mean by data.

 

Getting Started with MySql

MySql is a database application software. It helps you store and retrieve data without hitches, provided you know how to do it.in this tutorial, we will focus on MySql from the backend, that is, focusing on the query language without adding much other programming Languages. An idea of a programming Language will be an added advantage for you to understand more about databases.

How to Install MySql On Windows Operating System.

Installing MySql on Windows is now much easier than how it used to be when we started using it. For this tutorial, we are going to be making use of MySql Server and Mysql query browsers.

Installing MySql Server

With these simple steps, Mysql Server can be downloaded on your Windows OS using Mysql Installer.

1. Visit dev.mysql.com/downloads/installer
2. Select Mysql Server. It is important to install Mysql Server before installing Mysql Query Browser.
3. Select the Version of Mysql you desire to Install and the bit contained in your system. It is either a 32-bit or 64-bit operating system. it will be a good idea to pause and check what your operating system is made of. Note: Mysql server is 32bit and can install for 32 and 64bits, respectively.
4. Execute the file which you Downloaded.
5. Choose the appropriate setup which you would like to work with. But I prefer the developer default so that you can install other tools you might need in the long run. for example, the Mysql WorkBench. Or you choose Custom Setup and Manually select the tools you want to install.
6. Allow Automatic Installation processes to take place
7. Type and Networking.

• Select the Server Machine.
• Enable TCP/IP Networking by ticking the check box.
• Leave the default port Number.
• Select add firewall

8. Root Account Password: Enter the password and repeat the same password you entered. Note That the root user can be said to be the admin.
9. Add a role to Mysql User Account.
10. MySql Server Configuration.

     . Specify Windows Service Name.

     . Tick the checkbox if not selected to allow Mysql to start at system start-up automatically.

     . Select the standard System Account because it is mostly recommended.

 

11. Click next to the Configuration Overview page and allow the configuration to complete.
12. Bravo, you are good to go with Mysql Server or should I say, command Line Client? Yes.
13. Let’s try running it to see if it was successfully installed.

• Run The Command Line from Your System
• Enter the root password you used during registration
• Type ‘use mysql;’ hey, not too fast, don’t forget to add the semi-colon
• Hit the enter key.
• If the result is ‘Database Changed’,
• Then Congratulations

Use the Comment Column to drop your feedback, we will be glad to hear from you. 

Please do subscribe and always come back for more