Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

Ovid (2709)

Ovid
  (email not shown publicly)
http://publius-ovidius.livejournal.com/
AOL IM: ovidperl (Add Buddy, Send Message)

Stuff with the Perl Foundation. A couple of patches in the Perl core. A few CPAN modules. That about sums it up.

Journal of Ovid (2709)

Thursday April 17, 2008
09:26 AM

MySQL Grant Pain

[ #36175 ]

mysql> grant all on no_such_database.* to 'no_such_user'@'%' identified by 'some_password';
Query OK, 0 rows affected (0.00 sec)

No warning. No problem. This is real fun to debug.

Also, when you drop a database, grants aren't dropped. We found this out when it turned out we had over 1.5 million grants left in the database. This had an impact on performance.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • ... that apparently MySQL is a bit like Perl, the first thing you need to do is "use strict"...

    Have you enabled strict mode?

    Note: I have no freaking idea how to turn it on myself, but I think it's being positioned as a "gotcha" ala use strict.
    • mysql> set @@session.sql_mode='traditional';
      Query OK, 0 rows affected (0.01 sec)

      mysql> SELECT @@session.sql_mode;
      +---------------------------------------------------------- ---------------------------------------------------------------------+
      | @@session.sql_mode