Changes between Version 5 and Version 6 of howto/MySQL

Timestamp:

Jan 4, 2015, 11:08:33 PM (9 years ago)

Author:

magill@…

Comment:

upd

howto/MySQL

@@ -15 +15 @@
 }}}
 
-= Step 2: create a database =
+= Step 2: Create a database =
 {{{
  '''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.
 
+Wrapper no longer exists...
+
 {{{
 -- HOW TO USE THIS FILE (with a MacPorts installation):
--- $ sudo /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop
+
+--$ sudo port unload mysql56-server
+
 -- $ sudo mysqld_safe --init-file=mysql_security.sql &
 -- 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.  
 
-See also http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix
+See also http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html#resetting-permissions-unix
 
 
-= Step 6: Optional database upgrade = #mysql_upgrade
+= Step 6: Database upgrade as necessary = #mysql_upgrade
 
 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)
 sudo port unload mysql56-server
-sudo /opt/local/lib/mysql5/bin/mysql_upgrade -u root -p
+sudo /opt/local/lib/mysql56/bin/mysql_upgrade -u root -p
 sudo port load mysql56-server
 }}}