| 211 | == mysql == |
| 212 | |
| 213 | /usr/bin/mysql_secure_installation has been run to secure the server: |
| 214 | |
| 215 | {{{ |
| 216 | In order to log into MySQL to secure it, we'll need the current |
| 217 | password for the root user. If you've just installed MySQL, and |
| 218 | you haven't set the root password yet, the password will be blank, |
| 219 | so you should just press enter here. |
| 220 | |
| 221 | Enter current password for root (enter for none): |
| 222 | OK, successfully used password, moving on... |
| 223 | |
| 224 | Setting the root password ensures that nobody can log into the MySQL |
| 225 | root user without the proper authorisation. |
| 226 | |
| 227 | You already have a root password set, so you can safely answer 'n'. |
| 228 | |
| 229 | Change the root password? [Y/n] n |
| 230 | ... skipping. |
| 231 | |
| 232 | By default, a MySQL installation has an anonymous user, allowing anyone |
| 233 | to log into MySQL without having to have a user account created for |
| 234 | them. This is intended only for testing, and to make the installation |
| 235 | go a bit smoother. You should remove them before moving into a |
| 236 | production environment. |
| 237 | |
| 238 | Remove anonymous users? [Y/n] y |
| 239 | ... Success! |
| 240 | |
| 241 | Normally, root should only be allowed to connect from 'localhost'. This |
| 242 | ensures that someone cannot guess at the root password from the network. |
| 243 | |
| 244 | Disallow root login remotely? [Y/n] y |
| 245 | ... Success! |
| 246 | |
| 247 | By default, MySQL comes with a database named 'test' that anyone can |
| 248 | access. This is also intended only for testing, and should be removed |
| 249 | before moving into a production environment. |
| 250 | |
| 251 | Remove test database and access to it? [Y/n] y |
| 252 | - Dropping test database... |
| 253 | ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist |
| 254 | ... Failed! Not critical, keep moving... |
| 255 | - Removing privileges on test database... |
| 256 | ... Success! |
| 257 | |
| 258 | Reloading the privilege tables will ensure that all changes made so far |
| 259 | will take effect immediately. |
| 260 | |
| 261 | Reload privilege tables now? [Y/n] y |
| 262 | ... Success! |
| 263 | |
| 264 | Cleaning up... |
| 265 | |
| 266 | All done! If you've completed all of the above steps, your MySQL |
| 267 | installation should now be secure. |
| 268 | |
| 269 | Thanks for using MySQL! |
| 270 | }}} |
| 271 | |