<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<br><div><html>On Apr 1, 2008, at 9:08 AM, Bill Hernandez wrote:</html><br class="Apple-interchange-newline"><blockquote type="cite"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span class="Apple-style-span" style="-webkit-text-stroke-width: -1; ">On Apr 1, 2008, at 4:58 AM, <a href="mailto:sourceforge.rocks@xemaps.com">sourceforge.rocks@xemaps.com</a> wrote:</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div> <blockquote type="cite"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">A reference to this error log was in the message that appeared when the "sudo -u mysql mysql_install_db5" command to create the initial tables failed.</div> </blockquote><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Since I converted to Leopard, I am using a MySQL binary install until I can get around to doing the whole MacPorts install, but basically depending upon whether it's a MacPorts install or not the only thing that should really change is the path to the script :</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">(your path to where the script is located would be different than mine)</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">In my case when I am using :</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">shell> $ cd /usr/local/mysql</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">shell> /usr/local/mysql $ sudo ./scripts/mysql_install_db</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I'm not quite sure why you are using "sudo -u mysql mysql_install_db5"</div></blockquote><div><br></div><div>The following is displayed to the terminal after the successful completion of the "$ sudo port install mysql5 +server" command:</div><div><html><font class="Apple-style-span" face="'Courier New'"> ###########################################################</font></html><html><font class="Apple-style-span" face="'Courier New'"> # A startup item has been generated that will aid in</font></html><html><font class="Apple-style-span" face="'Courier New'"> # starting mysql5 with launchd. It is disabled</font></html><html><font class="Apple-style-span" face="'Courier New'"> # by default. Execute the following command to start it,</font></html><html><font class="Apple-style-span" face="'Courier New'"> # and to cause it to launch at startup:</font></html><html><font class="Apple-style-span" face="'Courier New'"> #</font></html><html><font class="Apple-style-span" face="'Courier New'"> # sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist</font></html><html><font class="Apple-style-span" face="'Courier New'"> ###########################################################</font></html><html><font class="Apple-style-span" face="'Courier New'"> ---> Installing mysql5 5.0.51_0+server</font></html><html><font class="Apple-style-span" face="'Courier New'"> ******************************************************</font></html><html><font class="Apple-style-span" face="'Courier New'"> * In order to setup the database, you might want to run</font></html><html><font class="Apple-style-span" face="'Courier New'"> * sudo -u mysql mysql_install_db5</font></html><html><font class="Apple-style-span" face="'Courier New'"> * if this is a new install</font></html><html><font class="Apple-style-span" face="'Courier New'"> ******************************************************</font></html><div><br></div></div><div>Note the instructions in that last comment box.</div><div><br></div><div>I was just copying and pasting the commands.</div><div><br></div><br><blockquote type="cite"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">following "sudo" there should be a command, not a switch "-u"</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">As I recall, for the MacPorts install you might try :</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">shell> $ sudo mysql_install_db5 --user=mysql</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I assume your $PATH includes /opt/local/lib/mysql5/bin</div></blockquote><div><br></div><div>Yes, it does.</div><br><blockquote type="cite"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">if you are not sure, cd into it...</div></blockquote><div><br></div><div>Actually, a simple "echo $PATH" works.</div><br><blockquote type="cite"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">shell> $ cd /opt/local/lib/mysql5/bin</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">shell> /opt/local/lib/mysql5/bin/ $ sudo mysql_install_db5 --user=mysql</div></blockquote><div><br></div><div>The "sudo -u ...." command seems to have worked (after the temp/mysql5 directory was properly created).</div><br><blockquote type="cite"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Best Regards,</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Bill Hernandez</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Plano, Texas</div> </blockquote></div><br><div>Cheers,</div><div>Mike.</div></body></html>