Changes between Version 67 and Version 68 of howto/MAMP

Timestamp:

May 12, 2014, 10:56:44 PM (11 years ago)

Author:

cooljeanius (Eric Gallager)

Comment:

start of rewrite for transition from mysql5 port to mysql51 port

howto/MAMP

@@ -151 +151 @@
 
 If you merely want to access a MySQL server running on another computer, skip to step 4. If you want to run a MySQL server on this computer, install MySQL like this:
-
-{{{
-sudo port install mysql5-server
-}}}
-
-Set up the main database
-
+{{{
+sudo port install mysql51-server
+}}}
+mysql51-server is used in this example because it is the closest to the port that was previously used in this example, which was mysql5-server. However, there are newer versions of mysql in MacPorts that may be worth considering instead. The only reason for not using any of these newer versions in this example is because that would probably require making even more changes than the move to mysql51 required. If you are personally moving from the mysql5 port to the mysql51 port, you may want to add the `+openssl` variant, as the openssl support that had previously been available by default in the mysql5 port has been moved to a variant in the mysql51 port. Even though the mysql51-server port does not have this variant itself, if you supply the variant with your invocation of `port`, it will still get passed down to the mysql51 port, because it will be installed as a dependency. Also, mysql51 now uses the `port select` mechanism, so you will have to run one of the following to get the mysql commands in your PATH: either:
+{{{
+sudo port select mysql mysql51
+}}}
+or:
+{{{
+export PATH=$PATH:/opt/local/lib/mysql51/bin
+}}}
+Once you have done at least one of the two previous commands, you can then set up the main database like this:
 {{{
 sudo -u mysql mysql_install_db5 
-sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ 
-sudo chown -R mysql:mysql /opt/local/var/run/mysql5/ 
-sudo chown -R mysql:mysql /opt/local/var/log/mysql5/ 
-}}}
-
-  ''If that doesn’t work try this:''
+sudo chown -R mysql:mysql /opt/local/var/db/mysql51/ 
+sudo chown -R mysql:mysql /opt/local/var/run/mysql51/ 
+sudo chown -R mysql:mysql /opt/local/var/log/mysql51/ 
+}}}
+
+  ''If that fails to work, then try this:''
   {{{
 sudo mysql_install_db5 
-sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ 
-sudo chown -R mysql:mysql /opt/local/var/run/mysql5/
+sudo chown -R mysql:mysql /opt/local/var/db/mysql51/ 
+sudo chown -R mysql:mysql /opt/local/var/run/mysql51/
   }}}
 
 Activate your MySQL server installation so that it autostarts when you boot your machine:
-
-{{{
-sudo port load mysql5-server
-}}}
-
-and then verify that it’s running
-
+{{{
+sudo port load mysql51-server
+}}}
+
+and then verify that it is running:
 {{{
 ps -ax | grep mysql
 }}}
 
-Set the MySQL `root` password (it’s currently empty, see also the security option below):
-
+Set the MySQL `root` password (it should currently be empty, see also the security option below):
 {{{
 mysqladmin5 -u root -p password <new-password> 
 }}}
 
-where `<new-password>` is your new desired root password. You will be prompted for your existing password ("`Enter password:`"); since it’s empty, just press Return.
+where `<new-password>` is your new desired root password. You will be prompted for your existing password ("`Enter password:`"); since it is empty, just press Return.
 
 Test everything by logging in to the server.
-
 {{{
 mysql5 -u root -p
 }}}
 
-Once you’re logged in, simply exit the session
-
+Once you are logged in, simply exit the session like this:
 {{{
 mysql> exit ;
 }}}
 
-If desired, reboot your machine and then run
-
+If desired, reboot your machine and then run:
 {{{
 ps -ax | grep mysql
 }}}
-
 again to verify that the daemon is again running.
 
@@ -223 +221 @@
 sudo /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart
 }}}
+(note: these instructions might not be applicable any longer...)