Re: Newbie: Access Denied trouble

[Sasha Pachev]

> > > mysqladmin: connect to server at 'localhost' failed
> > > error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> > >
> > > Ciao for now,
> > >
> > > --EdB  <edb@stripped>
> > > http://www.geocities.com/Area51/3339/
> >
> > Did you run mysql_install_db ?
> Yes... and not just once!
> 
> > Did you set the root password?
> >
> I tried.  This is another case in point where I get the error...
> mysqladmin -u root password 'newpassword'
> 
> Ciao for now,
> 
> --EdB  <edb@stripped>
> http://www.geocities.com/Area51/3339/


Let's do this:

killall mysqld

/path/to/safe_mysqld --skip-grant
mysql mysql

update user set password = password('BigSecret') where user = 'root';
exit

mysqladmin shutdown
/path/to/mysql.server start

Now you should be able to connect as root with the password of BigSecret


-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)