Errors installing mysql5

[Ryan Schmidt]

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.