> -----Original Message----- > From: l...@beer.org.uk > Sent: Tue, 24 Feb 2009 13:19:52 -0000 (GMT) > To: hampshire@mailman.lug.org.uk > Subject: Re: [Hampshire] Which Perl Modules > > > Well, the thread title is wrong now - this is a MySQL question... > >> shell> mysql -e "GRANT ALL ON mwforum.* TO mwfo...@localhost IDENTIFIED >> BY >> 'password'" >> >> I have named my database msn so I assume mwforum.* should be msn.* > > Yes. > >> mwfo...@localhost I think should be m...@localhost > > Could be. In this context, "mwforum" and "msn" are MySQL usernames; use > whatever will remind you of their function in three years' time... > >> password is the password for mysql database?? > > It's the password for *that user*. > >> The error I am getting is >> >> Error 1045 (28000) Access denied for user 'root'@'localhost' (using >> passowrd: NO) > > Try adding "-p" to your mysql command. Make sure you know the root MySQL > password. > >> The stupid thing is I have setup the forum on a test machine and did not >> have a problem but doing it again on the server is causing me problems. > > Your test machine probably had no root MySQL password set. Your > production > machine definitely should... > > Vic. > >
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 ____________________________________________________________ FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop! Check it out at http://www.inbox.com/marineaquarium -- 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 --------------------------------------------------------------