Login to your Ubuntu server with root user with your favorite SSH client
Let’s first update the operating system with all the latest packages with the command
sudo apt-get update
In order to install mysql use the command as below
apt-get install mysql-server php5-mysql
On the next screen , set the root password for Mysql server , Use the tab to move the cursor on OK button and press enter.
We are done with installing Mysql
Let’s configure and secure the Mysql server in order to use it with the commands
mysql_install_db
mysql_secure_installation
In order to secure the Mysql installation you will need to answer a series of questions as below
Enter current password for root (enter for none): Provide the root password
Change the root password n
Remove anonymous users Y
Remove anonymous users Y
Disallow root logins remotely Y
Disallow root login remotely Y
Remove test database and access to it Y
And reload privilege tables Y
Reload privilege tables now Y
We are done with securing the Mysql server installation. Let’s verify it with the command
mysql –V
Lets restart the Mysql service with the command
service mysql restart
You are done.
