[Mediawiki-l] [OT] Create user accessing MySQL DB

[Andreas Tille]

Hi,

I wanted to access more than one MySQL databases to follow
   http://www.mediawiki.org/wiki/Manual:Wiki_family

One DB is called wikiDB1 and the according user is called
wikiDB1user.

According to
   http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
I tried

  GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON wikiDB1.* TO 'wikiDB1user'@'localhost' IDENTIFIED BY 'passwd';
  FLUSH PRIVILEGES;

but even

   $ mysql -u wikiDB1user -p wikiDB1

fails on command line so it is clear that I get

(Can't contact the database server: Access denied for user 'wikiFG31user'@'localhost' (using password: YES) (localhost))

on the Wiki page.

Sorry for asking MySQL specific questions here, but this seems the
quickest way for me as a bloody MySQL beginner to ask for help.

Thanks

        Andreas.

-- 
http://fam-tille.de