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.
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
Now we can check what Packages are installed with MySQL
dpkg –get-selections | grep mysql
Check Out: Restore & Backup Of MySQL Server
File location of MySQL is /etc/mysql/
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
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.
Now it will ask you to set up the password for root user (MySQL Server).
Keep following the above steps
- Remove anonymous user
- Remove default database test
- Disallow remote login
Now login MySQL server with root user.
Check Out: Recover/Reset Root Password Of MySQL Server
After login, you will get a MySQL prompt then check databases available.
YouTube Link: Install MySQL
That’s it. mysql install ubuntu check version