Also, make note that MediaWiki is version 1.9.3. If you are importing from the same version, importing ought to work. If not, you will likely need to upgrade your mediawiki version to match, then re-dump your MySQL and then import that into the JumpBox MySQL.
There is a debian-sys-maint user that should have complete access. Its password is in /etc/mysql/debian.cnf. Using this user and its password should 'mysql -u debian-sys-maint -p' should work for you.
Submitted by guyfarley on Mon, 09/10/2007 - 1:57pm.
Hi - I need to grant create table permissions to the wikiuser user so I can install the semantic wiki plugin. The debian-sys-maint user is denied access to the wikidb. Any other ideas - is there a reason you can't publish the root mysql root user?
Use the debian-sys-maint user's password (as shown in /etc/mysql/debian.cnf) for MySQL root user. That ought to work for you. Also, as bjan asked, what version of MediaWiki are you using?
Submitted by DennyBoll on Tue, 04/24/2007 - 9:59am.
I am trying to load my mediawiki database that replaces the default one. I got the password for wikiuser from LocalSettings.php, but it says DROP command denied. The admin password doesn't appear to be the mysql root password - so I am stuck... I guess my only recourse is to build my own mediawiki virtual machine...
root password for mysql
Also, make note that MediaWiki is version 1.9.3. If you are importing from the same version, importing ought to work. If not, you will likely need to upgrade your mediawiki version to match, then re-dump your MySQL and then import that into the JumpBox MySQL.
Good Luck,
Austin
root password for mysql
There is a debian-sys-maint user that should have complete access. Its password is in /etc/mysql/debian.cnf. Using this user and its password should 'mysql -u debian-sys-maint -p' should work for you.
debian-sys-maint user has no access permission
Hi - I need to grant create table permissions to the wikiuser user so I can install the semantic wiki plugin. The debian-sys-maint user is denied access to the wikidb. Any other ideas - is there a reason you can't publish the root mysql root user?
Thanks, Guy.
Use the debian-sys-maint
Use the debian-sys-maint user's password (as shown in /etc/mysql/debian.cnf) for MySQL root user. That ought to work for you. Also, as bjan asked, what version of MediaWiki are you using?
Austin
Try: sudo mysql
Try:
sudo mysql --defaults-extra-file=/etc/mysql/debian.cnf wikidbStill connects as debian-sys-maint
Hi, thanks but this still connects me to mysql as debian-sys-maint. So when i do:
grant all on wikidb.* to wikiuser
I get:
Access denied for user debian-sys-maint to database wikidb.
Cheers, Guy.
What version of the
What version of the MediaWiki JumpBox are you using?
root password for mysql
I am trying to load my mediawiki database that replaces the default one. I got the password for wikiuser from LocalSettings.php, but it says DROP command denied. The admin password doesn't appear to be the mysql root password - so I am stuck... I guess my only recourse is to build my own mediawiki virtual machine...