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.