[kwlug-disc] Bone headed mysql question (conflicting databases)

[Charles M]

I'm bumping into a mysql problem that I'm quite sure is simple and obvious,
but smacking my head against the wall as usual. I have 2 databases that
seem to conflict:

grant all on wordpress.* to 'myuser'@'localhost' identified by
'SomeFunnyPassword';
grant all on drupal.* to 'myuser'@'localhost' identified by
'AnEvenCrazierPassword';

What happens is that when I execute the second grant it seems to mess
up/deactivate the first database. If I then run the first grant on the
wordpress database the drupal database messes up/deactivates. Is it a
matter of needing to execute each database with a different username or not
using database.* (if not what then?)

Cheers and thanks.

Charles
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://kwlug.org/pipermail/kwlug-disc_kwlug.org/attachments/20120322/de21ecd4/attachment.htm>