mysqld

[George Toft]

Craig White wrote:
> 
> dummy me - I started the mysqld without a password and now I can't log
> in to make changes and set up users. How can I log in without a
> password? It won't let me log in without a password but there never was
> any - it's a new installation.
> 
> Craig
> 
> ________________________________________________
> See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post to the list quickly and you use Netscape to write mail.
> 
> PLUG-discuss mailing list  -  PLUG-discuss@lists.plug.phoenix.az.us
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss


My notes on how to break into, er, I mean, change the root password for
mysql:

# killall mysqld
# safe_mysqld -Sg &
# mysql mysql
mysql> select * from user;
mysql> update user set Password=password("newpasswd") where
User="root";  (or whatever your root user is called)

George