need mysql help setting passwd
Rodrigo Gonzalez
rjgonzale at gmail.com
Thu Jun 12 01:44:38 UTC 2008
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
More information about the freebsd-questions
mailing list