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
> > <[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]
