[MacPorts] howto/MySQL modified

MacPorts noreply at macports.org
Sun Jan 4 15:08:35 PST 2015


Page "howto/MySQL" was changed by magill at mac.com
Diff URL: <https://trac.macports.org/wiki/howto/MySQL?action=diff&version=6>
Revision 6
Comment: upd
Changes:
-------8<------8<------8<------8<------8<------8<------8<------8<--------
Index: howto/MySQL
=========================================================================
--- howto/MySQL (version: 5)
+++ howto/MySQL (version: 6)
@@ -14,7 +14,7 @@
 $ sudo port install mysql56-server
 }}}
 
-= 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. 
 It does NOT produce the equivalent path of the path command below. 
@@ -108,9 +108,13 @@
 
 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.
 -- Wait a bit to be sure the server is running.
@@ -131,17 +135,17 @@
 
 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.
 
 {{{
 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
 }}}
 == Starting and stopping the MySQL server ==
-------8<------8<------8<------8<------8<------8<------8<------8<--------

--
Page URL: <https://trac.macports.org/wiki/howto/MySQL>
MacPorts <https://www.macports.org/>
Ports system for OS X

This is an automated message. Someone added your email address to be
notified of changes on 'howto/MySQL' page.
If it was not you, please report to .


More information about the macports-changes mailing list