• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • About Us
  • Contact Us
  • Block Examples
  • Landing Page
Tech Robin Logo

Tech Robin | Technology News Blog

Best Technology News Blog on AI tools, metaverse, automation, Data Science, Device Tech, Software, Robotics, Tech Reviews, Finance, Health, and Tech Trends

  • Automation
    • Business Automation
    • Home Automation
    • Office Automation
  • Data Science
  • Device Tech
    • Smart Glasses
    • Smart Homes
    • Smart Phones
    • Smart TV
    • Smartwatches
    • Wearable Tech
    • Windows
  • Education Tech
  • Finance Tech
  • Health Tech
  • Tech Trends
    • AI tools
    • Cloud Computing
    • Cybersecurity
    • Internet of Things (IOT)
    • Machine Learning
    • Metaverse
    • Operating Systems
    • Robotics
    • Softwares
    • Tech Reviews
    • Virtual Reality

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

October 27, 2016 by Igbaji Chinwendu Leave a Comment

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

Post Outline

  • 1 MySQL Databases – MySQL Database and 13 Steps to Install MySQL Server
    • 1.1 Getting Started with MySql
    • 1.2 How to Install MySql On Windows Operating System.
    • 1.3 Installing MySql Server
    • 1.4 Share this:

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
  1. 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.
  2. Add a role to Mysql User Account.
  3. 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.

 

  1. Click next to the Configuration Overview page and allow the configuration to complete.
  2. Bravo, you are good to go with Mysql Server or should I say, command Line Client? Yes.
  3. 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

 

Share this:

  • Mysql Database – MySql Query Browser/How to install MySQl query Browser for Windows
  • October 28, 2016
  • Tech Trends
  • Tech Skills – 8 Tech Skills That Are In High Demand And Why
  • February 6, 2023
  • Tech Trends
  • Data Science – 5 Best Data Scientist Careers To Try
  • February 10, 2023
  • Data Science

Filed Under: Tech Trends

Reader Interactions

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

More to See

Samsung Unveils New Devices  – What You Need to Know About The Galaxy Z Fold 5, Z Flip 5, Watch 6 and Galaxy Tab S9

July 28, 2023 By Jael Okwuchukwu

YouTube Watch Time – 7 Possible Strategic Ways to Increase YouTube Watch Time 

July 10, 2023 By Jael Okwuchukwu

Footer

Text Widget

This is an example of a text widget which can be used to describe a particular service. You can also use other widgets in this location.

Examples of widgets that can be placed here in the footer are a calendar, latest tweets, recent comments, recent posts, search form, tag cloud or more.

Sample Link.

Recent

  • AI Image Generators –  Top 11 AI Image Generators And How to Generate AI Images
  • Samsung Unveils New Devices  – What You Need to Know About The Galaxy Z Fold 5, Z Flip 5, Watch 6 and Galaxy Tab S9
  • YouTube Watch Time – 7 Possible Strategic Ways to Increase YouTube Watch Time 
  • Ripple – TikTok Parent ByteDance Unveils AI-Powered Music Generator
  • AI in customer service -7 ways to increase productivity as a customer service Rep using Artificial Intelligence

Search

Copyright © 2023 · Tech Robin | Best Technology News Blog . Blog . Privacy . Contact . Sitemap