| | 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 | |