A. Installation:
1. Install MySQL
By default MySQL 5.5 will be installed.
2. Install MySQL Connector JAR file
B. Configuration:
1. Set password for root user:
2. Remove unneccessary information from log and STDOUT
3.Start / Stop / Restart MySQL
1. Install MySQL
1 | root@ubuntu:~# apt-get install mysql-server |
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 |