On Apr 1, 2008, at 9:08 AM, Bill Hernandez wrote:
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.
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 :
(your path to where the script is located would be different than mine)
In my case when I am using :
shell> $ cd /usr/local/mysql
shell> /usr/local/mysql $ sudo ./scripts/mysql_install_db
I'm not quite sure why you are using "sudo -u mysql mysql_install_db5"
The following is displayed to the terminal after the successful completion of the "$ sudo port install mysql5 +server" command:
########################################################### # A startup item has been generated that will aid in # starting mysql5 with launchd. It is disabled # by default. Execute the following command to start it, # and to cause it to launch at startup: # # sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist ########################################################### ---> Installing mysql5 5.0.51_0+server ****************************************************** * In order to setup the database, you might want to run * sudo -u mysql mysql_install_db5 * if this is a new install ******************************************************
Note the instructions in that last comment box.
I was just copying and pasting the commands.
following "sudo" there should be a command, not a switch "-u"
As I recall, for the MacPorts install you might try :
shell> $ sudo mysql_install_db5 --user=mysql
I assume your $PATH includes /opt/local/lib/mysql5/bin
Yes, it does.
if you are not sure, cd into it...
Actually, a simple "echo $PATH" works.
shell> $ cd /opt/local/lib/mysql5/bin
shell> /opt/local/lib/mysql5/bin/ $ sudo mysql_install_db5 --user=mysql
The "sudo -u ...." command seems to have worked (after the temp/mysql5 directory was properly created).
Best Regards,
Bill Hernandez
Plano, Texas
Mike.