Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 11 Jun 2008 22:17:32 -0300
From:      Rodrigo Gonzalez <rjgonzale@gmail.com>
To:        Gary Kline <kline@thought.org>
Cc:        FreeBSD Mailing List <freebsd-questions@FreeBSD.ORG>
Subject:   Re: need mysql help setting passwd
Message-ID:  <4850792C.7050200@gmail.com>
In-Reply-To: <20080612010303.GA81167@thought.org>
References:  <20080612010303.GA81167@thought.org>

next in thread | previous in thread | raw e-mail | index | archive | help
Gary Kline wrote:
> this failed:
> 
> 
> mysqladmin -u root password
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password: NO)'
> 
> 
> according to my logs it has been about 5 years since i did this last.
> 
> advice please!
> 
> gary
> 
> 
> 
Your mysql server already has a password for user root.

2 options

1 - mysqladmin -u root -p password

Of course I think you dont know current password or you wouldnt be
asking....so second option

Read
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix

with that steps you will reset root password

Best regards

Rodrigo Gonzalez



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4850792C.7050200>