Changes between Version 51 and Version 52 of howto/MAMP

Timestamp:

Apr 8, 2010, 8:01:57 PM (14 years ago)

Author:

dweber@…

Comment:

--

howto/MAMP

@@ -162 +162 @@
 }}}
 
-Set the MySQL `root` password (it’s currently empty):
+Set the MySQL `root` password (it’s currently empty, see also the security option below):
 
 {{{
@@ -189 +189 @@
 
 again to verify that the daemon is again running.
+
+
+==== Optional database upgrade ==== #mysql_upgrade
+
+If the database exists from a previous installation, you may need to upgrade.
+
+{{{
+man mysql_upgrade
+sudo /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart
+sudo /opt/local/lib/mysql5/bin/mysql_upgrade -u root -p
+sudo /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart
+}}}
+
+
+==== Optional security configuration ==== #mysql_security
+
+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.
+
+{{{
+-- HOW TO USE THIS FILE (with a MacPorts installation):
+-- $ sudo /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop
+-- $ sudo mysqld_safe5 --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.
+-- If it's running, then shutdown the server (root password required):
+-- $ /opt/local/bin/mysqladmin5 -u root -p shutdown
+-- Check that everything worked.  There may be an ERROR if the test database
+-- doesn't exist.  Otherwise there should be no errors in the file reported by
+-- 'mysqld_safe Logging to ..." during the mysql_safe5 startup from above:
+-- $ sudo tail -n 20 /opt/local/var/db/mysql5/*.err 
+
+UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
+DELETE FROM mysql.user WHERE User='root' AND Host!='localhost';
+DELETE FROM mysql.user WHERE User='';
+FLUSH PRIVILEGES;
+DROP DATABASE test;
+DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%';
+}}}
+
+See also http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix
+
+
 
 === Step 4: Install PHP === #php