I tried the 1.17 beta as well as the latest in phase3 for 1.17 and had the
same issue. Basically, when I run it on my own server, it works fine, no
issues, but when I run it on a hosted server, where I don't have full access
to MYSQL, but instead have full access to the specific database I'm using,
the installer throws an error, failing on "Create database user". Here's the
error (substituting in database and dbuser):
---
Granting permission to user "dbuser" failed: A database query syntax error
has occurred. The last attempted database query was: "GRANT ALL PRIVILEGES
ON `database`.* TO 'dbuser''" from within function
"MysqlInstaller::setupUser". Database returned error "1044: Access denied
for user 'dbuser'@'%' to database 'database' (database)" Backtrace:
1. 0
/home/content/18/7872418/html/mediawiki-1.17/includes/db/Database.php(751):
DatabaseBase->reportQueryError('Access denied f...', 1044, 'GRANT ALL
PRIVI...', 'MysqlInstaller:...', false)
2. 1
/home/content/18/7872418/html/mediawiki-1.17/includes/installer/MysqlInstaller.php(503):
DatabaseBase->query('GRANT ALL PRIVI...', 'MysqlInstaller:...')
3. 2 [internal function]:
MysqlInstaller->setupUser(Object(MysqlInstaller))
4. 3
/home/content/18/7872418/html/mediawiki-1.17/includes/installer/Installer.php(1293):
call_user_func(Array, Object(MysqlInstaller))
5. 4
/home/content/18/7872418/html/mediawiki-1.17/includes/installer/WebInstallerPage.php(1084):
Installer->performInstallation(Array, Array)
6. 5
/home/content/18/7872418/html/mediawiki-1.17/includes/installer/WebInstaller.php(246):
WebInstaller_Install->execute()
7. 6
/home/content/18/7872418/html/mediawiki-1.17/mw-config/index.php(46):
WebInstaller->execute(Array)
8. 7
/home/content/18/7872418/html/mediawiki-1.17/mw-config/index.php(14):
wfInstallerMain()
9. 8 {main}
---
What I don't understand is if I left the checkbox selected under "Database
account for web access" for "Use the same account as for installation", why
would it be trying to create the database user? Seems like a bug.
Since this is after the tables are created, I can back up to where I
selected the database, go forward again and it thinks it's an upgrade. The
wiki seems to create fine at that point except I don't have an
administrative account or any accounts for the wiki. I could create an
account, but it's just a normal user and I don't have an admin account
available to promote it.
Anyone have any insight? Workarounds?