List:General Discussion« Previous MessageNext Message »
From:Michael Wilson Date:November 17 2009 12:56am
Subject:Re: How to change root password?
View as plain text  
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
> <michaelwilson72@stripped> 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

Thread
How to change root password?Michael Wilson16 Nov
  • Re: How to change root password?Pintér Tibor16 Nov
  • Re: How to change root password?Alexey Mykhailov16 Nov
    • Re: How to change root password?Michael Wilson17 Nov
      • Re: How to change root password?John Daisley17 Nov
Re: How to change root password?Michael Wilson17 Nov