Errors installing mysql5
ryandesign at macports.org
Mon Sep 22 01:45:41 PDT 2008
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/
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
> 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
> 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:
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
> 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/
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 &
>  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:
I undid the incorrect part of that change.
> 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.
More information about the macports-users