On Tuesday 24 February 2009 14:16:22 Tim Henley wrote: > > -----Original Message----- > > From: sweseme...@ntlworld.com > > Sent: Tue, 24 Feb 2009 14:07:28 +0000 > > To: hampshire@mailman.lug.org.uk > > 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 t...@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 t...@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 t...@localhost IDENTIFIED BY 'timssqlpassword'; mysql> flush privileges; mysql>quit Cheers, Steve -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --------------------------------------------------------------
