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.