ERROR 1133: Can't find any matching row in the user table

I am a bit dwelling in the wonderful world of Microsoft Windows. And if you know me, you’d say: “WTF?!?”. Anyway, checking out some trick (which I’ll blog later) I tried a simple GRANT to see if the grant-tables were OK.

mysql> GRANT SELECT ON foo.* TO 'geert'@'localhost';
ERROR 1133 (42000): Can't find any matching row in the user table

Now that’s cryptic, isn’t it? Reason: SQL Modes!

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

The problem, or rather, the cool thing is the NO_AUTO_CREATE_USER. This prevents creating users without a password.

Comments

Geert JM Vanderkelen
Note that we opened a bug report for this: http://bugs.mysql.com/bug.php?id=43938