The latest version of MySQL 8.0 is available to install from the default AppStream repository.
MySQL module is enabled by default on the CentOS 8 and RHEL 8 systems.
We can install it using YUM command.
# yum -y install @mysql # systemctl start mysqld # systemctl enable --now mysqld # systemctl status mysqld
MySQL 8 Initial Security :
MySQL security script use to remove test MySQL server databases, remove anonymous users in the database, disable remote root login, set the password strength.
To run this script, we need to execute below command;
When run, you are prompted whether to enable or disable password policy. If enabled, set the password policy and create the password that matches your chosen policy.
It will ask you to configure “VALIDATE PASSWORD PLUGIN” which is used to test the strength of the MySQL users passwords and improve the security.
There are three levels of password validation policy, low, medium, and strong. Enter 0 , 1 or 2 as per your requirements.
Next, it will ask you to set a password for the MySQL root user.
Next, it will ask you to remove the anonymous user, restrict root user access to the local machine, and remove the test database.
You should answer “Y” (yes) to all those questions.
Once MySQL installation is secured, you can login to the MySQL and create new databases and users etc.
If you need any further assistance please do contact our support department at support@L3webhosting.com.