Skip to content

Installation: sql db for Fedora: securing mysql on CentOS

acozine edited this page May 17, 2013 · 2 revisions

Here's what you'll see and do when using /usr/bin/mysql_secure_installation to secure a newly installed mysql database on CentOS:

Enter current password for root (enter for none):
(hit ENTER here)
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL root user without the proper authorisation. Set root password? [Y/n]
(type y here)
New password:
(type your chosen root pw)
Re-enter new password:
(type that root pw again)
Password updated successfully!
Reloading privilege tables..
... Success!

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? [Y/n]`  
(type y here)  
` ... 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? [Y/n]`  
(type y here)  
` ... 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? [Y/n]`  
(type y here)  
` - 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? [Y/n]`  
(type y here)  
` ... Success!`
Clone this wiki locally