From: Date: March 18 1999 3:46pm
Subject: Re: access denied for user: 'root@localhost'
List-Archive: http://lists.mysql.com/mysql/493
Message-Id: <Pine.LNX.3.96.990318153515.188A-100000@chizma.glurp.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII



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