install mysql 5.7 ubuntu

MySql is an open source database server which is used to store data of any application and websites. It’s acquired by oracle. It’s widely used database server as of secure , scalability and good performance. It uses the port number 3306.

Check Out Installation of Mariadb On Redhat

Let’s install it , we’re going to install version 5.7 here on our machine along with client. If you’re root otherwise used below command with sudo

apt-get install mysql-server mysql-client

Now we can check what is installed with Mysql and command is

dpkg –get-selections | grep mysql

File location of Mysql is /etc/mysql/

Now it’s time to secure the Mysql and set the root password of database server for securing command is mysql_secure_installation

It will ask you set the length of password it’s depend on you if you want to specified the length of password.

Now it will ask you to setup the password of root ( Mysql Server )

Keep following above steps

  • Remove anonymous user
  • Remove default database test
  • Disallow remote login

Now login mysql server with root user and password which was set during this process.

After login you will get  a mysql prompt then check databases available.

You’re done

Sponsored

LEAVE A REPLY

Please enter your comment!
Please enter your name here