problems running mysql_install_db5
pixilla at macports.org
Thu Mar 24 20:54:55 PDT 2011
On Mar 24, 2011, at 4:04 PM, David Gentry wrote:
>>> 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.
More information about the macports-users