On 04/08/10 21:40, Sullivan, James (NIH/CIT) [C] wrote:
Hi all,
I have been installing many mediawiki wikis over the past few years using a remote mysql server. I do not use the mysql "root" account but instead use another user, which has had the proper privileges to install the database, until version 1.16.0. When I install the mediawiki version 1.16.0 into my document root directory and run the installation, the installation runs fine up to "Granting user permissions..." at which point I get:
Query "GRANT ALL PRIVILEGES ON 'database_name'.* TO 'database_user'@'%' IDENTIFIED BY 'database_password' " failed with error code "Access denied for user mysql_user@mysql_host to database 'database_name' (database_server)".
Just to make sure all was ok I was able to install version 1.15.2 without error.
Have the privilege requirements for the database user privileges changed from 1.15 to 1.16 for installing mediawiki? I did not see any mention of this in the release notes. I am using mysql version 5.1.16-beta.
Any help appreciated...
-Jim
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-lDid to
Did you try installing MediaWiki 1.15.5 to see if anything changed between then and now. Main Question: What permissions does your other user have? For my installs that I host locally, my MediaWiki db users have: SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, LOCK TABLES
The last is only really for locking the database for maintenance etc.
Lewis Cawte