List:General Discussion« Previous MessageNext Message »
From:Mark Keaney Date:March 18 1999 2:46pm
Subject:Re: access denied for user: 'root@localhost'
View as plain text  

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



Thread
access denied for user: 'root@localhost']tisniewaarhe18 Mar
  • Re: access denied for user: 'root@localhost']Micheal Mc Evoy18 Mar
  • Re: access denied for user: 'root@localhost'Mark Keaney18 Mar
Re: access denied for user: 'root@localhost'michel tisniewaarhe19 Mar
  • Re: access denied for user: 'root@localhost'Michael Widenius19 Mar
RE:access denied for user: 'root@localhost'michel tisniewaarhe19 Mar
Re: access denied for user: 'root@localhost'michel tisniewaarhe19 Mar
Re: access denied for user: 'root@localhost'michel tisniewaarhe19 Mar