How to Install MySQL on Ubuntu:

Step 1 - Installing MySQL

To install MySQL you need to update the package index on your server and then install the package with apt-get.

Write the following commands to install MySQL

$ sudo apt-get update
$ sudo apt-get install mysql-server

Now you'll be prompted to create a root password during the installation. Choose a secure password as you will be asked for the same password later.

Step 2- Configuring MySQL

$ sudo mysql_secure_installation

This command will prompt you for the root password you created in step one. Now you can press ENTER to accept the defaults for all the questions.

Next, we'll initialize the MySQL data directory, which is where MySQL stores its data. You can now check your version of MySQL with the following command.

$ mysql --version

You'll see some output like this:

OUTPUT

mysql  Ver 14.14 Distrib 5.7.11, for Linux (x86_64) using  EditLine wrapper

Step 3- Testing MySQL

MySQL should have started running automatically. To test this, check its status.

$ service mysql status

You'll see the following output (with a different PID).

mysql start/running, process 2689

If MySQL is not running, you can start MySQL with following commad line:

$ sudo service mysql start

All done now, MySQL is successfully installed on Ubuntu.

Thanks for reading this blog