None, of these suggestions worked...
Tried the following ways to reset the password:
(1) Shut down MySQL via System Preferences pane
(2) Placed the following in a text file:
UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root';
FLUSH PRIVILEGES;
(3 Invoked the following command from the command line in Bash:
mysqld_safe --init-file=/Users/raven/mysql-init &
[1] 2236
Received these errors:
mysqld_safe Logging to '/usr/local/mysql/data/Valkyrie.local.err'.
touch: /usr/local/mysql/data/Valkyrie.local.err: Permission denied
chown: /usr/local/mysql/data/Valkyrie.local.err: Permission denied
mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld_safe: line 105:
/usr/local/mysql/data/Valkyrie.local.err: Permission denied
rm: /usr/local/mysql/data/Valkyrie.local.pid: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 142:
/usr/local/mysql/data/Valkyrie.local.err: Permission denied
mysqld_safe mysqld from pid file /usr/local/mysql/data/Valkyrie.local.pid ended
/usr/local/mysql/bin/mysqld_safe: line 105:
/usr/local/mysql/data/Valkyrie.local.err: Permission denied
On Nov 15, 2009, at 11:37 PM, Alexey Mykhailov wrote:
> On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson
> <[email protected]> wrote:
>> I am running MySQL 5 on OS X Snow Leopard...
>>
>> Have it set up (by installing the pref pane) to always be running as
> soon
>> as my MacBook starts.
>>
>> For some odd reason, I can't remember the password I issued for "root"
>> user and wish to either change it back to blank or a new specific
> password.
>>
>> What should I type from the command line?
>>
>> When I tried:
>>
>> mysqladmin -uroot -p
>>
>> The Bash shell listed out all the possible arguments which the
> mysqladmin
>> could utilize:
>>
>> mysqladmin Ver 8.42 Distrib 5.4.3-beta, for apple-darwin9.5.0 on i386
>> Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
>> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
>> and you are welcome to modify and redistribute it under the GPL license
>>
>> Administration program for the mysqld daemon.
>> Usage: mysqladmin [OPTIONS] command command....
>> -c, --count=# Number of iterations to make. This works with -i
>> (--sleep) only.
>> --debug-check Check memory and open file usage at exit .
>> // etc
>>
>> Would appreciate if someone could help...
>>
>> -Michael
>
> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
