207 | | Place the following into {{{mysql_security.sql}}} and replace the {{{'MyNewPass'}}} with your root password. Note that the SQL will remove all access for root from any location other than 'localhost'. You might like to keep this SQL file - all the lines beginning with '--' are doc-comments about how to use it. |
| 207 | There is an interactive program to secure a MySQL installation. |
| 208 | |
| 209 | {{{ |
| 210 | $ man mysql_secure_installation |
| 211 | $ /opt/local/bin/mysql_secure_installation5 |
| 212 | }}} |
| 213 | |
| 214 | The following is a more detailed process that may achieve the same results as the interactive program. Place the following into {{{mysql_security.sql}}} and replace the {{{'MyNewPass'}}} with your root password. Note that the SQL will remove all access for root from any location other than 'localhost'. You might like to keep this SQL file - all the lines beginning with '--' are doc-comments about how to use it. |