my webserver and database server are separate boxes. I'm running the media wiki install script ,and it creates the wiki database and tables perfectly fine, but the grant sql statements fail.
Query "GRANT ALL ON `wikidb`.* TO wikiuser@'%' IDENTIFIED BY 'blah'" failed with error code "Access denied for user: 'root@XX-XX-XX-XX' to database 'wikidb'".
where XX-XX-XX is the ip address of my database server.
i'm installing the latest 1.3 beta6 version of mediawiki.
anyone got any pointers as to what's going wrong?
thanks.
justin flavin wrote:
my webserver and database server are separate boxes. I'm running the media wiki install script ,and it creates the wiki database and tables perfectly fine, but the grant sql statements fail.
Query "GRANT ALL ON `wikidb`.* TO wikiuser@'%' IDENTIFIED BY 'blah'" failed with error code "Access denied for user: 'root@XX-XX-XX-XX' to database 'wikidb'".
Perhpas your MySQL is configured not to allow GRANT privs to 'root' on other machines.
Set up the GRANT manually so that wikiuser can do the install, then use that rather than root.
-- brion vibber (brion @ pobox.com)
mediawiki-l@lists.wikimedia.org