![]() ![]() 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. ![]() You can secure MySQL using the mysql_secure_installation script. 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. ![]() 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. 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. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y Made so far will take effect immediately. To log in to MySQL, use the following command (note that it’s the same command you would use to log into a MySQL database): mysql -u root -pĬongratulations! You have successfully installed MySQL. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |