MySQL Server Installation in Ubuntu 18.10

Hi, this post discuss the installation of MySQL Server in Ubuntu-18.10.

You can install the same in many different ways you like, but this post talks about installing MySQL Server using "Advanced Package Tool" simply apt

This Advanced Package Tool comes default with Debian, Ubuntu and related Linux Distributions.

This procedure is not just for this particular distribution of Ubuntu but for other distributions too....

To install MySQL Server, you need to have Administrator Rights... so make sure you logged into the system with an account(Linux Login Account) with administrator rights

Open a terminal and issue the following command at the prompt..

 > which mysql

The above command gives the location of mysql executable.

/usr/bin/mysql

If nothing appears conveys us it is yet to be installed.

to install MySQL Server issue the following command at the prompt

 > sudo apt-get install mysql-server

the above command would prompt you to provide the password, provide the one associated with the account

Now the package manager i.e Advanced Package Tool would install MySQL Server

Be patience till the process is completed.

After the installation is completed, at the terminal issue the same command which we had used to check mysql service is installed. i.e "which mysql"

The response would give a valid location of mysql which is nothing but the client to connect to the database server.

The acutal server executable is mysqld whose location can be located the using the following

 > which mysqld

The above command would print out the location of the mysqld executable, usually you will be locating mysqld in the following folder

/usr/sbin/mysqld

With this we can confirm that MySQL Server is installed successfully but still we have not checked it is up and running or not

To have that check issue the following command at the prompt...

 > sudo service mysql status

If the server is not up and running

you can start the server as follows..

 > sudo service mysql start 

Now you should have mysql server instance for service.

to verify, execute the command "sudo service mysql status", which would result in response something like the one shown in the image below...

With this we have concluded the installtion of MySQL Server in Ubuntu-18.10

Thanks...