MySQL Installation on Ubuntu 14.04

posted on Nov 20th, 2016

MySQL

MySQL is an open-source relational database management system (RDBMS). It's name is a combination of "My", the name of co-founder Michael Widenius' daughter, and "SQL", the abbreviation for Structured Query Language.

The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.

Pre Requirements

1) A machine with Ubuntu 14.04 LTS operating system installed.

Installation Steps

MySQL Installation on Ubuntu

The following steps to install MySQL on your machine.

Step 1 - Installing MySQL Server. Open a terminal (CTRL + ALT + T) and type the following sudo command.

$ sudo apt-get install mysql-server

MySQL Installation on Ubuntu 14.04

During mysql-server installation it will ask password to enter for root, give it as 'root' or something else. In my case i have given it as root to remember easily.

Step 2 - Installing MySQL Java Connector. This will install libraries (mysql-connector-java.jar) in /usr/share/java/ folder using that we can connect MySQL using Java.

$ sudo apt-get install libmysql-java

Step 3 - Entering into MySQL command line inteface(CLI).

$ mysql -u root -p

Enter password

Enter password :****

Now you can use MySQL database.

mysql>

Please share this blog post and follow me for latest updates on

facebook             google+             twitter             feedburner

Previous Post                                                                                          Next Post

Labels : Creating New Users in MySQL   Connecting to MySQL with Java