Changes between Version 5 and Version 6 of howto/MySQL
- Timestamp:
- Jan 4, 2015, 11:08:33 PM (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
howto/MySQL
v5 v6 15 15 }}} 16 16 17 = Step 2: create a database =17 = Step 2: Create a database = 18 18 {{{ 19 19 '''NOTE:''' This needs a definition of the "Port Slect" mechanism. i.e. explain what it does. … … 109 109 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. 110 110 111 Wrapper no longer exists... 112 111 113 {{{ 112 114 -- HOW TO USE THIS FILE (with a MacPorts installation): 113 -- $ sudo /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop 115 116 --$ sudo port unload mysql56-server 117 114 118 -- $ sudo mysqld_safe --init-file=mysql_security.sql & 115 119 -- The init will terminate if there are any errors in the init file. … … 132 136 The server startup options {{{--skip-networking}}} and {{{--skip-grant-tables}}} may be useful while implementing security. 133 137 134 See also http://dev.mysql.com/doc/refman/5. 0/en/resetting-permissions.html#resetting-permissions-unix138 See also http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html#resetting-permissions-unix 135 139 136 140 137 = Step 6: Optional database upgrade= #mysql_upgrade141 = Step 6: Database upgrade as necessary = #mysql_upgrade 138 142 139 143 If the database exists from a previous installation, you may need to upgrade. … … 142 146 man mysql_upgrade -- details on the upgrade program (man page) 143 147 sudo port unload mysql56-server 144 sudo /opt/local/lib/mysql5 /bin/mysql_upgrade -u root -p148 sudo /opt/local/lib/mysql56/bin/mysql_upgrade -u root -p 145 149 sudo port load mysql56-server 146 150 }}}