How to Install MySQL on ubuntu Server

By | September 27, 2015

MySQL Installation on ubuntu Server – Learn more about MySQL and master how to use it.

What is MySQL?

MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.

Remember the best way to learn any new technical skill, is to play around and see how things work. Get comfortable you’re few steps in right direction. Click HERE to Order Your VPS NOW! so that you can gain the practical experience needed.

Now 50% OFF! VPS hosting solutions optimized for you: Click HERE to Order NOW!

Now, to install MySQL, run the following command from a terminal prompt:

root@gs2~# apt-get install mysql-server && apt-get install mysql-client

During the installation process you will be prompted to enter a password for the MySQL root user.

Once the installation is complete, the MySQL server should be started automatically. You can run the following command from a terminal prompt to check whether the MySQL server is running:

root@gs2~# netstat -tap | grep mysql

When you run this command, you should see the following line or something similar:

tcp        0      0 localhost:mysql         *:*                     LISTEN      2194/mysqld

If the server is not running, nothing will be displayed, you can type the following command to start it:

root@gs2:~# service mysql start && service mysql restart
mysql start/running, process 2611
mysql stop/waiting
mysql start/running, process 2700

You can edit the /etc/mysql/my.cnf file to configure the basic settings: log file, port number, etc.

That’s it for today,

In the next guide I will provide a basic step-by-step guide on how to improve the security of your MySQL installation!!!