problems running mysql_install_db5

[Bradley Giesbrecht]

On Mar 24, 2011, at 4:04 PM, David Gentry wrote:

>>> Bradley,
>>> 
>>> I ran the commands you gave me on Mar. 18, and they all ran fine except the very last one:
>>> 
>>> $ mysqladmin5 -p -u root password 'xxxxxxxxx'
>>> Enter password: 
>>> mysqladmin5: connect to server at 'localhost' failed
>>> error: 'Access denied for user 'root'@'localhost' (using password: YES)'
>> 
>> Leave off the -p.
>> 
>> $ mysqladmin5 -u root password 'xxxxxxxxx'
>> 
>> So you have MacPorts mysql5-server running now, right?
>> $ ps ax | grep mysql5
> 
> $ mysqladmin5 -u root password 'xxxxxxxxx'
> $
> 
> Leaving off the -p seems to work.
> 
> $ ps ax | grep mysql5
> 60877   ??  Ss     0:00.37 /opt/local/bin/daemondo --label=mysql5 --start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart ; --pid=none
> 60887   ??  S      0:00.02 /bin/sh /opt/local/lib/mysql5/bin/mysqld_safe --datadir=/opt/local/var/db/mysql5 --pid-file=/opt/local/var/db/mysql5/DAVID.local.pid
> 60937   ??  S      0:31.48 /opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5 --user=_mysql --log-error=/opt/local/var/db/mysql5/DAVID.local.err --pid-file=/opt/local/var/db/mysql5/DAVID.local.pid
> 71358 s000  R+     0:00.01 grep mysql5
> 
> Unless you see something wrong in the result above, the MacPorts mysql5-server is running.  Yesterday, everything ran exactly as you said it would except for setting the root password, and now the root password appears to be set.
> 
> Thank you very much.  This is a milestone for me.

Great David, looks good. Glad it worked out for you.

--
Brad