Mysql5 password reset

[Ryan Schmidt]

You need to use the "Reply To All" feature of your mail program so  
your reply goes to the mailing list also, not just to me. More  
answers below:

On Feb 6, 2007, at 14:49, Watson Ladd wrote:

> Ryan Schmidt wrote:
>
>> On Feb 6, 2007, at 14:20, Watson Ladd wrote:
>>
>>> I recently forgot my mysql password. When following the  
>>> instructions on
>>> mysql.com to reset it I was able to stop the mysqld daemon through
>>> launchctl, but when I started mysqld manually with the skip grant  
>>> tables
>>>  option it complained about being unable to lock files and became a
>>> runaway process that did not respond to keyboard input.
>>
>> So what is your question?
>>
>> You've provided very few details... we need more information, like:
>>
>> - What is the URL of the instructions you followed?
>>
>> - What are the commands you entered?
>>
>> I can guess at a few things:
>>
>> - When you started mysqld manually, did you do so as root or with  
>> sudo?
>> You would need to.
>>
>> - When you started mysqld manually, did you have "&" at the end of  
>> the
>> command line? If so, that detaches the process from the terminal and
>> explains why you can see output but not provide input. If you want  
>> to be
>> able to provide input to the process, do not use "&".
>
> I did not use &. The command I used for restart was
> $sudo -u mysqld /opt/local/libexec/mysqld --skip-grant-tables
> According to the mysqld documentation, this should start mysqld  
> without
> passwords. Previously I used
> $sudo launchctl stop org.macports.mysql5 to kill mysqld. It is  
> possible
> that an abandoned lockfile might exist. If so, where is it?

I don't know about any such lockfile, but likely places to look might be

/opt/local/etc/mysq5/
/opt/local/var/db/mysql5/
/opt/local/var/run/mysql5/

If that doesn't help, could you show us the exact error messages  
you're seeing? Have you already searched Google for those error  
messages?