Differences

This shows you the differences between two versions of the page.

--- install_apache_mysql_php_linux_ubuntu_server [2020/06/08 16:20] – [Creating Additional Virtual Hosts] wikiadmin
+++ install_apache_mysql_php_linux_ubuntu_server [2020/06/08 16:25] – [Install MySQL Database Server] wikiadmin
@@ Line 162: / Line 162: @@
 Enter this command:
+<code>sudo mysql_secure_installation</code>
+<code>
+Securing the MySQL server deployment.
+Connecting to MySQL using a blank password.
+VALIDATE PASSWORD COMPONENT can be used to test passwords
+and improve security. It checks the strength of password
+and allows the users to set only those passwords which are
+secure enough. Would you like to setup VALIDATE PASSWORD component?
+Press y|Y for Yes, any other key for No: y
+There are three levels of password validation policy:
+LOW    Length >= 8
+MEDIUM Length >= 8, numeric, mixed case, and special characters
+STRONG Length >= 8, numeric, mixed case, special characters and dictionary  file
+Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 2
+Please set the password for root here.
+New password:
+Re-enter new password:
+Estimated strength of the password: 100
+Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
+By default, a MySQL installation has an anonymous user,
+allowing anyone to log into MySQL without having to have
+a user account created for them. This is intended only for
+testing, and to make the installation go a bit smoother.
+You should remove them before moving into a production
+environment.
+Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
+Success.
+Normally, root should only be allowed to connect from
+'localhost'. This ensures that someone cannot guess at
+the root password from the network.
+Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
+Success.
+By default, MySQL comes with a database named 'test' that
+anyone can access. This is also intended only for testing,
+and should be removed before moving into a production
+environment.
+Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
+ - Dropping test database...
+Success.
+ - Removing privileges on test database...
+Success.
+Reloading the privilege tables will ensure that all changes
+made so far will take effect immediately.
+Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
+Success.
+All done!
+</code>