[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