Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

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

by barrd (Abbot)
on Nov 27, 2003 at 10:40 UTC ( #310503=note: print w/replies, xml ) Need Help??


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."
      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."

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://310503]
help
Chatterbox?
[Corion]: Oh yay. The (external, not guided by me) programmers have chosen Moose+DBIx::Class for some implementation, and now seem to do 1+n SELECT statements for each row, as is usual when using ORMs.
[Corion]: So maybe I should investigate how to plug in a cache in front of DBIx::Class so I can do a ->selectall_hashre f and then satisfy the "sub"-selects from that cached single SELECT statement ...
[erix]: then you might as well send that patch to the DBIC guys :)

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (6)
As of 2017-09-25 11:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    During the recent solar eclipse, I:









    Results (279 votes). Check out past polls.

    Notices?