Ubuntu Server 14.04 - MySQL 5.5 installation and configuration

A. Installation:
1. Install MySQL

1	root@ubuntu:~# apt-get install mysql-server

 By default MySQL 5.5 will be installed.


2. Install MySQL Connector JAR file

1	root@ubuntu:~# apt-get install mysql-connector-java*

B. Configuration:
1. Set password for root user:

1	root@ubuntu:~# mysqladmin -u root -p'<your_password_here>' password $mysqlpassword

2. Remove unneccessary information from log and STDOUT

1	root@ubuntu:~# mysqladmin -u root 2>&1 >/dev/null

3.Start / Stop / Restart MySQL

1 2 3

root@ubuntu:~# service mysql start root@ubuntu:~# service mysql stop root@ubuntu:~# service mysql restart