GRANT SELECT errors

7 views
Skip to first unread message

Pete Boyd

unread,
Jul 9, 2009, 4:44:56 AM7/9/09
to goldfish-user
On this page:
http://www.remofritzsche.com/goldfish/index.php?page=installation-configuration-manual-2

You say:
"mysql> GRANT SELECT ON `mailserver`.`autoresponder` TO `goldfish`
IDENTIFIED BY PASSWORD('myPassword');"

You don't include the UPDATE privilige. Without it you get a couple of
"Error in query UPDATE `autoresponder` SET `enabled`..." errors.

The ` characters don't work for me.

'PASSWORD('myPassword')' doesn't work for me.

I do this:
GRANT SELECT,UPDATE ON mailserver.autoresponder TO goldfish IDENTIFIED
BY 'mypassword';

remofritzsche

unread,
Jul 9, 2009, 5:51:06 AM7/9/09
to goldfish-user
Thanks a lot! I have changed it in the newest manual for version 1.0.
It's online.

Remo

On Jul 9, 10:44 am, Pete Boyd <petes-accou...@thegoldenear.org> wrote:
> On this page:http://www.remofritzsche.com/goldfish/index.php?page=installation-con...
Reply all
Reply to author
Forward
0 new messages