Re: access denied for user: 'root@localhost'

[Mark Keaney]

On Thu, 18 Mar 1999, tisniewaarhe wrote:

> Ladies, gents,
> 
> I've done the bad thing. I modified the record for user root to allow
> access to the database from another machine. It didn't work. Neither
> does root@localhost anymore. in fact nobody can connect anymore it
> seems.
> 
> I erased the mysql contents and recreated the database with
> my_install_db

If you've (re)installed the mysql database then the root user has no password.
So try to connect without using a password and don't use the -p switch.

> 
> when I run   mysqladmin -root password '<the root pw>'   I get
> 
> " access denied for user: 'root@localhost' (Using password: YES)"
> 
> Is there still hope?
> 
> If you think RTFM/ RTFFAQ please point me in right direction as I
> haven't seen it so far, havent looked for the right words when I search
> 
> Michel
> 
> 

mark@stripped