List:General Discussion« Previous MessageNext Message »
From:John Daisley Date:November 17 2009 1:33am
Subject:Re: How to change root password?
View as plain text  
Make sure your mysql server is not accessible to anyone else, its a good
idea to disconnect all network connections because the server will be
totally insecure for a short period of time!

Start your MySQL server with the --SKIP-GRANT-TABLES option.

At a shell prompt type 

	mysql -uroot 

(you may have to add -h and -p options to the command above if you are
using a non-standard host or port). You should get a mysql prompt, at
the mysql prompt type 

	USE mysql;

Followed by

	FLUSH PRIVILEGES;

Then type

	UPDATE user set password = password('new_pass') 
	where user='root';

Replacing new_pass with your desired password.
Now type

	FLUSH PRIVILEGES;
	EXIT;

and restart the server without --SKIP-GRANT-TABLES

Regards


On Mon, 2009-11-16 at 16:56 -0800, Michael Wilson wrote:
> 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