> -----Original Message-----
> From: lug@???
> Sent: Tue, 24 Feb 2009 13:19:52 -0000 (GMT)
> To: hampshire@???
> 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 mwforum@localhost IDENTIFIED
>> BY
>> 'password'"
>>
>> I have named my database msn so I assume mwforum.* should be msn.*
>
> Yes.
>
>> mwforum@localhost I think should be msn@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 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
____________________________________________________________
FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop!
Check it out at
http://www.inbox.com/marineaquarium
