Cannot set mysql 5.1.39_0 root password

[Chang James]

Hi ,
  I have installed mysql 5.1.39_0 and do thw following steps to initial db
and set root's password of my mySQL server.

Step 1.

sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist


Step 2.

sudo -u mysql mysql_install_db5


Step 3.

/opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password'


Step 1 and Step 2 are successful but faild in Step 3.

It show me the following error message:


{{{

error: 'Access denied for user 'root'@'localhost' (using password: NO)'

}}}


By the way, MySQL will start up during boot time, how should I do if I want
to manually stop/start mysql daemon for database maintenance?


Best Regards!



James Chang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20090926/929ba990/attachment.html>