I am trying to install MySQL on Ubuntu 12.04.
I want to use this command sudo mysql_secure_installation
in Terminal, but I don't know the purpose of this command.
mysql_secure_installation is a shell script developed for securing the MySQL server installation on Unix systems. The script configures security settings and allows you to: Set a password for root accounts (see how to reset or change MySQL root password) Remove the root accounts accessible from outside the localhost.
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.
mysql_install_db initializes the MySQL data directory and creates the system tables that it contains, if they do not exist. It also initializes the system tablespace and related data structures needed to manage InnoDB tables.
The default user for MySQL is root and by default it has no password. If you set a password for MySQL and you can't recall it, you can always reset it and choose another one.
It's designed to set a few initial parameters that are more secure than the default Ubuntu (and MySQL) installation.
According to http://dev.mysql.com/doc/refman/5.6/en/mysql-secure-installation.html:
This program enables you to improve the security of your MySQL installation in the following ways:
- You can set a password for root accounts.
- You can remove root accounts that are accessible from outside the local host.
- You can remove anonymous-user accounts.
- You can remove the test database (which by default can be accessed by all users, even anonymous users), and privileges that permit anyone to access databases with names that start with test_.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With