Advanced
Mailing List Archive

Mailing List Archive

  1. Home >
  2. Wikipedia>
  3. Mediawiki
mysql grant problems with installation
justin at global-investor
Aug 11, 2004, 4:37 AM
Post #1 of 2 (363 views)
Permalink
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.

--
Jf, sysadmin
------------------------------
Re: mysql grant problems with installation [ In reply to ]
brion at pobox
Aug 11, 2004, 11:16 AM
Post #2 of 2 (358 views)
Permalink
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)

Attached Files:

©2024 GT.net. A Gossamer Threads company.
5th Floor, 455 Granville St., Vancouver, BC V6C 1T1, Canada | Legal