Site icon Experiences Unlimited

MySQL: World’s Most popular Open Source database

What is MySQL?

MySQL is an Open Source database management system(DBMS) that one can download for free from MySQL Website ( MySQL is one of the world’s most popular systems for Java web applications because of its consistent fast performance, high reliability and ease of use. MySQL runs on more than 20 platforms including Linux, Windows, OS/X, HP-UX, AIX, Netware, giving the developers right kind of flexibility. 

MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now a subsidiary of Sun Microsystems, which holds the copyright to most of the codebase. The project’s source code is available under terms of the GNU General Public License, as well as under a variety of proprietary agreements.

Why is MySQL more popular among Web Developers?

What does MySQL Provide?

How to install MySQL database?

Visit the MySQL Download site (Link) and locate the download page for MySQL Community Server.

Save the installation file on to the hard disk. Run the msi file by double clicking on it.

Accpet all the default options and install MySQL on to your computer.

Respond to the MySQL configuration wizard to configure the MySQL on your computer. Here you will have to set the root password. Choose a fairly easy to remember password. You will be using this password during connection to the database. The default username is “root“.

Interacting with MySQL:

Command Line Tool:


GUI Tools:

MySQL GUI Tools include MySQL Administration and the MySQL Query Browser tool. One can download the GUI tools here.

MySQL Query Browser:

The Connection dialog box for Query browser

The Connection dialog box for Administrator Tool

Installing JDBC Driver for MySQL:

Before one can use Java to access MySQL database, need to install a database driver for MySQL. One has to download JDBC driver names Connector/J from MySQL

Other MySQL Connectors can be downloaded from here.

Connecting to MySQL database service

The MySQL database service starts automatically whenever you start your computer, this is referred to as the database server or database engine. Using MySQL GUI tools one can make a connection to the database server by providing the required details. Once you start the MySQL Query browser you will be shown the dialog box as shown above. You can either store the connection or can specify the connection details each time you try to connect to the database server. The server host by default will have the value “localhost” and the port of 3306 (the default port for most of the database servers). You will also be asked the root username and password. Username will be “root” and the password will be the one specified during the MySQL installation. 

MySQL Administrator Tool:

Once the Administrator tool is connected to the instance of the database service, you can start and stop the service by selecting the Service Control group and clicking the stop Service Button. One can also use the Administrator tool to manually start the database service whenever want to work with the database.

Advantages/Features of MySQL

To summarize MySQL provides whole lot of options to make database development and related activities easier, cheaper and faster. Its the best DBMS currently available and is used on a large scale in the LAMP/WAMP stack.

Exit mobile version