Re: Read only error when writing to db (OT?)

[barrd]

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)

[bradcathey]

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?

[bradcathey]

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)