This is the first tutorial on MySQL that will guide you through the basics of MySQL which includes what MySQL is, how to connect to the MySQL database using wampserver and the manual installation procedure of MySQL without using wampserver.
MySQL is a Relational Database Management System (RDBMS) and is a freely-available software. Developed by MySQL AB, it is used as an open-source database in the whole world. A number of applications like WordPress, Joomla, Drupal, etc use MySQL database. The term MySQL has been coined from the name “My”, daughter of its co-founder Michael Widenius. And SQL stands for Structured Query Language.
It was released in January 1998. One of the popular database used with web applications, it is fast, reliable and has high performance. It can be run in different platforms like Windows, Linux, Unix and Mac OS. It works with many languages like PHP, C, C++, Java, PERL, etc.
When you installed PHP using wampserver 2.2 as described in the tutorial Installation Procedure of PHP 5.4.6 in Windows 7, you must have seen MySQL installed automatically with PHP.
When you click the wampserver, you see “MySQL Console” option under “MySQL” .
On clicking it, you get a window asking for password. After you enter password which is actually the password for the user “root”, you enter mysql where you can run mysql commands.
You can also install MySQL separately which is a very simple procedure. Go to the website http://www.mysql.com/downloads/installer/ and download the latest version of MySQL.
Installation Steps of MySQL in Windows 7:
1) Double click on the installer. Click next to start the set up.
2) Select “Typical” installation and press next to continue.
3) Click on install to start installation. It may take few minutes to complete the process.
4) Select to configure the MySQL server and press next.
5) Select “Detailed Configuration” and “Server Machine” among the options and press next.
6) Select “Non-transactional database only” and press next.
7) Select “OLAP” and press next. Keep everything default in the next steps.
8) Enter new password for the user “root”. Remember and save this password at secure place as this password will be used to run MySQL command Line.
9) Press finish and MySQL is installed. Restart your computer and start running MySQL commands.
Once you have the installation done, move on to the next tutorial. In case of any queries in the installation or about the basics of MySQL, leave a comment below. In the upcoming tutorials, MySQL and MySQL commands will be discussed in detail.
