List:General Discussion« Previous MessageNext Message »
From:System Administrator a.k.a. The Root of the Problem Date:February 15 2002 3:38am
Subject:Re: admin privilege problems
View as plain text  
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
Thread
admin privilege problemsVictoria Reznichenko12 Feb
  • Re: admin privilege problemsSystem Administrator a.k.a. The Root of the Problem15 Feb
Re: admin privilege problemsEgor Egorov15 Feb
  • Re: admin privilege problemsSystem Administrator a.k.a. The Root of the Problem15 Feb