Author: Vic Date: To: Hampshire LUG Discussion List Subject: Re: [Hampshire] Which Perl Modules
>>> Error 1045 (28000) Access denied for user 'root'@'localhost' (using
>>> passowrd: NO)
>
> OK still failing, this is what I am typing
>
> mysql -e -p "GRANT ALL ON msn.* TO tim@localhost IDENTIFIED BY
> 'timssqlpassword'"
OK, there was only really one place that you could put the "-p" that would
cause a problem - and you picked it...
Don't split the "-e" (execute statement) from the statement you want to
execute...
> Error 1045 (28000) Access denied for user 'tim'@'localhost' (using
> password: NO)
Right, you've also changed user - you're now tim, not root. You'll need to
add "-u root" to run as the root user. Again, don't split the "-e" from
its statement.
> Am I being really dumb here??
You might want to open up the man page so you can work out what these
commands are doing...
