In this blog, we will learn What is MySQL? And also step by step how to install MySQL on the Windows platform using the MySQL Installer and Xampp. Similarly, we will talk about more platforms.
Direct Switch to Contents:
- What is MySQL?
- How to install and download MySQL?
- Steps to download MySQL Server for Windows
- Steps to download XAMPP for Windows
- WAMP MySQL
What is MySQL and a brief history?
So far we have learned enough about Data, Database, DBMS, RDBMS, and SQL before going to understand MySQL.
MySQL is one of the most popular open-source which means freely available Relational Database Management System.
It works on many Operating System (OS) like Windows, Linux, Macintosh (Apple OS), Solaris, FreeBSD.
It was first designed and developed by a Swedish Company- MySQL AB in the year 1994. And the first time it releases in 1995 as open-source. But Later MySQL is now owned by Oracle Corporation in 2010.
Now Oracle Corporation has two main Database Products or systems are Oracle Database which is not open Source and MySQL which is open source.
Its database system is used by popular companies some of which are Twitter, YouTube, Facebook, Uber, Netflix, Amazon, Sony, GitHub, etc.
It is not a programing Language but it uses the language that is SQL. MySQL is software that broadly written in C/C++ and is used to manage databases. Actually MySQL is a server-side software for the Relational Database Management System.
It is not completely free, some of the products of MySQL are paid like MySQL Standard Edition, MySQL Enterprise Edition, MySQL Cluster Carrier Grade Edition. But MySQL Web server is Completely Free. MySQL server supports a very large database having millions of records.
How to install and download MySQL?
Before downloading and installing any software, let us understand which software or platform is best for the purpose of learning and practice.
To learn and practice either you can download and install MySQL server any version or MySQL Workbench or both. The basic difference is MySQL Workbench gives you the friendly user interface and MySQL server is just a command-line prompt that is just a black screen to write queries.
There is another way we can learn MySQL that is XAMPP which is completely free and open-source software. In addition, XAMPP is a cross-platform web server software which consists of Apache, MySQL (now MariaDB), PHP, Perl. XAMPP can be used in both User interface and also Command Line prompt. I’ll suggest you use Command Line prompt mode for better learning.
I will suggest you choose either XAMPP or MySQL server. Don’t go for Workbench.
XAMPP is a free and open-source cross-platform web server solution stack package developed by Apache Friends, consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages.
MySQL Community SERVER:
It is a freely downloadable version of the world’s most popular open-source database that is supported by an active community of open source developers and enthusiasts. MySQL Cluster Community Edition is available as a separate download.
It is a graphical tool for working with MySQL. MySQL Workbench provides an easy to use interface for performing the many tasks involved when working with databases. It integrates SQL development, administration, database design, creation, and maintenance into one visual integrated development environment.
Steps to download MySQL Server for Windows:
1.Go to Google and search “MySQL server download”
Click here any of the two links and then you will the MySQL Community Server. Download it respect to 32-bit system or 64-bit system and Install it.
In simply you can just download the MySQL Installer and install it. Here giving you the link to download “MySQL Community Server” and Snap shows the same URL “https://dev.mysql.com/downloads/installer/ “.
Hereafter the installation, You will have both the MySQL Server Command Line prompt and Also the MySQL Workbench.
- Here I am installing MySQL Server 5.5 version. I have downloaded the setup or executable file(EXE File).
Double click on it. You will see this
After that click next
Agree the Licence Agreement then click next. You will see
Click on typical and install it then click next-next finish. After that a window open MYSQL server Instance Configuration Wizard-like this
Click next and you will see
Then do the next-next install and finish it.
Now search the MySQL in the search box, you will see MySQL Command-line Client.
Steps to download XAMPP for Windows:
Here we will use XAMPP to learn MySQL.
1. Search on google XAMPP download. Then you will the
Here Giving you the same link for download “Xampp Download”.
2. After that click on first link search you will see
3. Choose any of the downloads and just simply install it.
After the installation is done, open XAMPP Control Panel and you will see something like this
Start the Apache and MySQL. In XAMPP we will use only the command line prompt. Now you are ready to use MySQL services. We use MySQL in XAMPP by Command line prompt and also by GUI (User Interface). Here we well learn by Command Line prompt but we need to set up it first.
How to setup XAMPP MySQL by Command Line Prompt?
First you need to start the MySQL server and Apache from the XAMPP Control Panel.
First open command line prompt by simply search in your computer after the complete XAMPP installation. After that, you will see something like this
From here we need to change the path to MySQL where we have installed XAMPP. By default, XAMPP is installed in our C drive.
Here I am giving the complete path where the XAMPP MySQL is installed C:\xampp\mysql\bin
Now what we will do is to change the path in command Prompt to
Just type – cd/
And after that hit enter
So Then type- cd/xampp/mysql/bin
Then hit enter you will be in MySQL bin directory after that type and enter- mysql -u root -p -h 127.0.0.1
Here –u is for the user that is the root and –p is for the password. We didn’t create the password while installing the XAMPP. If you have created the password while installing XAMPP the after –p write it. And -h is the server name which is 127.0.0.1 by default.
Then it we will be asking password just hit enter again.
Then we are ready to use MySQL services. Here it looks like
Here the one thing definitely you all have noticed that is MariaDB instead of MySQL. Lets taking a brief history of MySQL and MariaDB.
After the MySQL acquisition to Oracle in 2010, the founder Michael Monty Widenius of MySQL decided to fork MySQL and, designed and developed the MariaDB. MariaDB is a fork of MySQL. Indexes of MariaDB and MySQL are the same. Both don’t have many changes. MariaDB is still open-source database and remains free under the GNU General Public License.
There is another software that is widely used for MySQL learning. WAMP is an open-source web development package which in turn stands for Windows Apache MySql and PHP. WAMP is a package for the only windows environment, for any other platform like Linux, Apple OS you can use XAMP.
Along with MySQL, AMPPS also provides the developers to work with MongoDB Database. To manage the databases and tables, phpMyAdmin for MySQL and RockMongo for MongoDB is provided.
Where can I download Wamp?
- Download the WAMP stack from here:http://www.ampps.com/download. Download the one under the Windows section.
- Run the setup Ampps-setup.exe to start the installation.
- Select the Path where you want to install the WAMP Stack.
- Let the installation complete.
So, do not bother about it just learn and have practice.
The above we discussed the MySQL and it’s an installation on Windows using MySQL Installer and XAMPP.
MySQL is the database product of Oracle corporation and is open-source and freely available. Not a programming language but uses the standard language i.e. SQL
About the installation of this software, we can use MySQL server or MySQL workbench
And there is another way XAMPP i.e. user interface and command-line prompt.
In the above steps the given to ease the access of SQL server both for XAMPP and MySQL server in windows.
It depends on which purpose we use the database. Here we are leaning from the first step, so for the learning point of view and starting from basic MySQL Community SERVER & XAMPP, both are best. Pick any one or simply First Use MySQL Community SERVER then switch to XAMPP.
SQL is not a tool anyway. It is just a basic language that is used to operate data of DATABASES in Relational DBMS. If we talking about different database tools are MySQL, MySQL Workbench, Oracle, PostgreSQL, SQLite, etc.
The best way to practice MySQL is to start writing and executing the queries using your own data. Because of open source MySQL, It is free and for the learning point of is the best way.
Previous Blog | First Steps Lead To Mastering MySQL Database Learning