Installation of Mysql 5.7 Database Server On Ubuntu 17.10/18.04

Installation of MySQL 5.7 is an Open Source Relational Database server which is used to store data of any application and websites. MySQL is a widely used Relational database server It uses the Port number 3306. We can install and check the MySQL version in ubuntu.

The latest version of MySQL Server is 8.0 which Now available on the Official site of MySQL. This is Secure, Scalability, and provides Good Performance.

Security Improvements:

1. MySQL now enables the database administrators to establish automatic Password expiration.

2. The installation creates no test database.

3. To make it secure, MySQL server compiled using OpenSSL can automatically generate missing SSL and RSA Certificates.

4. Administrators can lock and unlock accounts for better control over who can log in.

Check Out: Installation of MariaDB On Redhat

Installation of Mysql 5.7 Database Server:

Let’s install it, we’re going to install version 5.7 here on our machine along with the client. If you root user otherwise, you can use below command with “sudo”

apt-get install mysql-server mysql-client

mysql install ubuntu

Now we can check what Packages are installed with MySQL  

dpkg –get-selections | grep mysql

Check Out: Restore & Backup Of MySQL Server

ubuntu mysql version

File location of MySQL is /etc/mysql/

install mysql ubuntu

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

Check Out:  Enable Slow Query In MySQL

mysql_secure_installation

It will ask you to set the length of the password. it depends on you. If you want to specify the length of the password.

how to install mysql in ubuntu

Now it will ask you to set up the password for root user (MySQL Server).

mysql installation in ubuntu 18

Keep following the above steps

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

install mysql ubuntu

Now login MySQL server with root user.

Check Out: Recover/Reset Root Password Of MySQL Server

mysql version check ubuntu

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

YouTube LinkInstall MySQL

That’s it. mysql install ubuntu check  version

Share on:

I'm the founder of Curious Viral. I hope this blog will provide you complete information about Linux Technology & I would like to share my technical knowledge with you which I have learned during this period.

Other Posts You May Like...

Leave a comment