When I try and log in with the new password I get this error:
Error 1045: Access denied for user: 'root@localhost' (Using password: YES).
The instructions that I followed required me to kill the mysqld process and
restart it with the --skip-grant-tables option and log into the root account
without a password. Then it told me to run this command:
UPDATE user SET Password=PASSWORD('mynewspecialpassword') WHERE User='root';
MySQL returned with it saying "quary compleated 0 rows affected" then I was
told to flush privlliges, which I did, and restart the mysqld process
normally. After trying all that it still didn't work.
Thanks and Regards
Biswa Ranjan Das(S.E.),
Olive e-Business Pvt. Ltd.,
B-1/H-2, Mohan Cooperative,
Mathura Road,New Delhi -110044
Ph : +91 11 26991100, 26991101, 26991102
Extn : 221
Fax : +91 11 26991110
Mobile : +91 9811344535
Information contained in this E-MAIL being proprietary to Olive e-Business
Pvt.Ltd. is 'privileged' and 'confidential' and intended for use only by the
individual or entity to which it is addressed. You are notified that any
use, copying or dissemination of the information contained in the E-MAIL in
any manner whatsoever is strictly prohibited.
----- Original Message -----
From: "Stuart Felenstein" <stuart4m@stripped>
To: <hf0722x@stripped>; <mysql@stripped>
Sent: Tuesday, September 14, 2004 2:52 PM
Subject: Re: HelpPlease: Conditional loop confusion
> Not sure exactly what you mean by a SQL injection
> attack. I'm thinking a string could be input as
> opposed to an integer ?
> The form itself constricts user to a set of choices.
> --- Harald Fuchs <hf0722x@stripped> wrote:
> > I think this is bad advice, even for a novice like
> > Stuart, because it
> > is susceptible to SQL injection attacks. I don't
> > know if PHP has
> > prepared statements like Perl DBI; if not,
> > $daterange should either be
> > quoted or checked in PHP if it's really a number.
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: