Reloading the privilege tables will ensure that all changes Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y This is also intended only for testing,Īnd should be removed before moving into a production This ensures that someone cannot guess atĭisallow root login remotely? (Press y|Y for Yes, any other key for No) : yīy default, MySQL comes with a database named 'test' thatĪnyone can access. Normally, root should only be allowed to connect from Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
You should remove them before moving into a production Testing, and to make the installation go a bit smoother. you should read and below each step carefully which will set a root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MySQL: mysql_secure_installationĬonfigure it like this: By default, a MySQL installation has an anonymous user,Īllowing anyone to log into MySQL without having to haveĪ user account created for them.
You can secure MySQL using the mysql_secure_installation script.
Once the installation is completed, the MySQL service will start automatically, you can verify it by typing: sudo systemctl status mysqlĪfter the installation of MySQL is complete, you may need to secure your new MySQL.
0 kommentar(er)
