On Tuesday 24 February 2009 14:16:22 Tim Henley wrote:
> > -----Original Message-----
> > From: swesemeyer@???
> > Sent: Tue, 24 Feb 2009 14:07:28 +0000
> > To: hampshire@???
> > Subject: Re: [Hampshire] Which Perl Modules
> >
> >> In reverse order, yes I do have a password on mysql which I did not
> >> before
> >>
> >> OK still failing, this is what I am typing
> >>
> >> mysql -e -p "GRANT ALL ON msn.* TO tim@localhost IDENTIFIED BY
> >> 'timssqlpassword'"
> >>
> >> Error 1045 (28000) Access denied for user 'tim'@'localhost' (using
> >> password: NO)
> >>
> >> and the error I get is the same as before
> >>
> >> I have tried changing the localhost to IP address and the name of the PC
> >> but still the same.
> >>
> >> Am I being really dumb here??
> >>
> >> Tim
> >
> > Hiya,
> >
> > try
> >
> > mysql -e -u root -p "GRANT ALL ON msn.* TO tim@localhost IDENTIFIED
> > BY 'timssqlpassword'"
> >
> > Cheers.
> > Steve
>
> Hi Steve
>
> All that done was list all the possible commandline options, same as mysql
> --help
>
> Tim
>
> ____________________________________________________________
> FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on
> your desktop! Check it out at http://www.inbox.com/marineaquarium
You probably have sorted it by now with Vic's last email but alternatively do
the following:
mysql -u root -p
[enter mysql root user password when prompted]
You should now be at a mysql prompt
mysql> GRANT ALL ON msn.* TO tim@localhost IDENTIFIED BY 'timssqlpassword';
mysql> flush privileges;
mysql>quit
Cheers,
Steve
