On Sep 22, 2008, at 2:50 AM, Fra Daniele di Gesù ocd wrote: > J. M. † J. T. > > I have just installed the latest one, mysql5 5.0.67_1+server. > > I am following instructions here http://trac.macports.org/wiki/ > howto/MAMP.
Since I didn't write those instructions, I'd like to redirect this conversation to the macports-users mailing list where others can comment too. Please Reply All from now on so the discussion can stay there. > At this line: sudo chown -R mysql:mysql /opt/local/var/run/mysqld5/ > This answer: chown: /opt/local/var/run/mysqld5/: No such file or > directory > Now I changed the line this way: sudo chown -R mysql:mysql /opt/ > local/var/run/mysql5/ (correct folder is mysql5 and not mysqld5) > Infact no answer by the command line: no problem. Thanks; I fixed the wiki page: http://trac.macports.org/wiki/howto/MAMP?action=diff&version=18 FYI, you can edit wiki pages too. Just sign up for an account, if you don't have one already. > At this line: sudo chown -R mysql:mysql /opt/local/var/log/mysql5/ > Same problem: chown: /opt/local/var/log/mysql5/: No such file or > directory > Here I do not know what to do: no log folder exist. > Perhaps I have to change it with this one: /opt/local/lib/mysql5/ > mysql/? No, /opt/local/var/log/mysql5 is the correct directory for MySQL logfiles. If it does not exist, you can create it. I should probably have the mysql5 port create this directory. I'm not sure if a ticket has already been filed on that. > Now I am following the instructions: > sudo /opt/local/bin/mysqld_safe5 & > [1] 11269 > > ps -ax | grep mysql > 34 ?? Ss 0:00.01 /opt/local/bin/daemondo --label=mysql5 > --start- > cmd /o > 72 ?? S 0:00.02 /bin/sh > /opt/local/lib/mysql5/bin/mysqld_safe --datad > 98 ?? S 0:34.36 /opt/local/libexec/mysqld > --basedir=/opt/local --data > 1126 p1- S 0:00.01 sudo > /opt/local/lib/mysql5/bin/mysqld_safe > 1127 p1- S 0:00.01 sudo > /opt/local/lib/mysql5/bin/mysqld_safe > 1128 p1- S 0:00.01 sudo > /opt/local/lib/mysql5/bin/mysqld_safe > 11269 p1 S 0:00.01 sudo /opt/local/bin/mysqld_safe5 > 11271 p1 S+ 0:00.00 grep mysql I don't know why it says to manually run "mysqld_safe5". That shouldn't be necessary. Running "sudo launchctl load -w /Library/ LaunchDaemons/org.macports.mysql5.plist" should start the MySQL server for you. Perhaps the order of the commands shown in the wiki page is wrong. For example I'm pretty sure you should install the initial database before attempting to start the server. But I don't have time right now to try setting up MySQL from scratch. Hopefully somebody else does and can correct the instructions. > mysqladmin5 -u root password -p > Enter password: > mysqladmin5: Too few arguments to change password Thanks. This error was introduced into the wiki here: http://trac.macports.org/wiki/howto/MAMP?action=diff&version=12 I undid the incorrect part of that change. http://trac.macports.org/wiki/howto/MAMP?action=diff&version=19 > mysql5 -u root -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 7 > Server version: 5.0.67 Source distribution > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > Just now it seems good. But there are some errors to correct in the > instruction page. Well, you still need to set your root password. Correct instructions for that are now in the wiki. > Thank you. > > I hope what I did is ok. Tell me, please. _______________________________________________ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users