Cannot set mysql 5.1.39_0 root password

[Ryan Schmidt]

On Sep 26, 2009, at 09:56, Andrea D'Amore wrote:

> On 26/set/09, at 10:34, Chang James wrote:
>
>> error: 'Access denied for user 'root'@'localhost' (using password:  
>> NO)'
>
> Can you connect by using regular mysql5 client? Try with and w/o  
> password option.

Yes, I believe you need the -p flag:

mysqladmin5 -u root -p password <new-password>

These are the instructions shown in the MAMP how-to document:

https://trac.macports.org/wiki/howto/MAMP#mysql


>> 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?
>
> port offers "load" and "unload" actions as shorcuts to launchctl.

Unfortunately they are broken in MacPorts 1.8.0. This will be fixed in  
1.8.1.