On Tue, Feb 05, 2002 at 07:10:01PM +0200, Victoria Reznichenko wrote:
> jeremy,
>
> Tuesday, February 05, 2002, 6:40:29 PM, you wrote:
>
> jr> hello,
>
> jr> i made the mistake of changing my root password manually in the mysql
> jr> database. after doing so, i 'flushed privileges'.
>
> jr> now i'm unable to log on using the root. i've tried to log on using the new
> jr> password a number of times, but i'm always denied access. strangely enough,
> jr> other users (that have passwords) can log on successfully without providing
> jr> a password. does anybody have any recommendations for logging on as the root
> jr> user ... and fixing this privileges problem?
>
> Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html
> It will help you.
>
> jr> thx
> jr> jeremy
>
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/
> This email is sponsored by Ensita.net http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Victoria Reznichenko
> / /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> <___/ www.mysql.com
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread98628@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-cyon=bestweb.net@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread99223@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-root=mail.nl2k.ab.ca@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
What if you run into:
Script started on Thu Feb 14 20:35:44 2002
doctor.nl2k.ab.ca//var$ mysqladmin -h localhost -u root password 'Nathan84'
mysqladmin: unable to change password; error: 'You must have privileges to update tables
in the mysql database to be able to change passwords for others'
doctor.nl2k.ab.ca//var$ exuit it
exit
Script done on Thu Feb 14 20:35:56 2002
--
contact:
Dave Yadallee NetKnow The Internet Knowledge Company
root@stripped http://www.nl2k.ab.ca
990-3244
