http://qs1969.pair.com?node_id=310503


in reply to Read only error when writing to db (OT?)

Hi bradcathey,
...I GRANTed liberally, and still problems...

After doing the grant privileges, you did remember to flush didn't you?

mysql> FLUSH PRIVILEGES;

Otherwise it will not work! ;)

Update: Added link to MySQL flush command syntax (www.mysql.com)

Replies are listed 'Best First'.
Re: Re: Read only error when writing to db (OT?)
by bradcathey (Prior) on Nov 27, 2003 at 13:49 UTC
    Thanks for the reply barrd, but I did remember to flush (I can't believe I just said that :-) and still....Maybe I need to reboot?

    —Brad
    "A little yeast leavens the whole dough."
[reply]
      That was it! Rebooting did it. MySQL had to be restarted for some reason. Thanks all, and sorry for the obvious oversight. (forgot my three rules of computing: 1) reboot the printer. 2) reboot the machine, 3) RTFM)

      —Brad
      "A little yeast leavens the whole dough."
[reply]

In Section Seekers of Perl Wisdom