Hello all,
I can't seem to make it past the final hurtle when trying to setup another wiki instance using my same database. In the setup options I am trying to give the new Wiki a "Database table prefix" so that I can use the same database and run multiple wikis...but one I hit "Install MediaWiki", all goes well until right at the end when I get this:
Creating tables... using MySQL 4 table defs...Query "CREATE TABLE `gec_user` ( user_id int(5) unsigned NOT NULL auto_increment, user_name varchar(255) binary NOT NULL default '', user_real_name varchar(255) binary NOT NULL default '', user_password tinyblob NOT NULL default '', user_newpassword tinyblob NOT NULL default '', user_email tinytext NOT NULL default '', user_options blob NOT NULL default '', user_touched char(14) binary NOT NULL default '', user_token char(32) binary NOT NULL default '', user_email_authenticated CHAR(14) BINARY, user_email_token CHAR(32) BINARY, user_email_token_expires CHAR(14) BINARY, user_registration CHAR(14) BINARY, PRIMARY KEY user_id (user_id), UNIQUE INDEX user_name (user_name), INDEX (user_email_token) ) TYPE=InnoDB " failed with error code "CREATE command denied to user 'wikiuser'@'localhost' for table 'gec_user' (localhost)".
It will let me setup a new wiki without using the prefix, but then that shares the original wiki's data....and that isn't what I need to do.
Appreciate any help I can get.
Thanks, Dave
Surely this is just a database permissions error. Have a look at what tables the user wikiuser has access to.
Arthur
arthur@assys.net
________________________________
From: mediawiki-l-bounces@Wikimedia.org on behalf of David_S_Green@Dell.com Sent: Mon 16/10/2006 17:13 To: mediawiki-l@Wikimedia.org Subject: [Mediawiki-l] Can't configure multiple Wikis?
"CREATE command denied to user 'wikiuser'@'localhost' for table 'gec_user' (localhost)".
It will let me setup a new wiki without using the prefix, but then that shares the original wiki's data....and that isn't what I need to do.
Appreciate any help I can get.
Thanks, Dave
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
I've triple checked that I am using the correct database password. Is there somewhere in MySQL I need to check?
Dave
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Arthur Guy Sent: Monday, October 16, 2006 11:29 AM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Can't configure multiple Wikis?
Surely this is just a database permissions error. Have a look at what tables the user wikiuser has access to.
Arthur
arthur@assys.net
________________________________
From: mediawiki-l-bounces@Wikimedia.org on behalf of David_S_Green@Dell.com Sent: Mon 16/10/2006 17:13 To: mediawiki-l@Wikimedia.org Subject: [Mediawiki-l] Can't configure multiple Wikis?
"CREATE command denied to user 'wikiuser'@'localhost' for table 'gec_user' (localhost)".
It will let me setup a new wiki without using the prefix, but then that shares the original wiki's data....and that isn't what I need to do.
Appreciate any help I can get.
Thanks, Dave
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Maybe your DB doens't support InnoDB and just MyISAM? That was my problem, and I manually edited maintenance/tables.sql changing the InnoDB type to MyISAM.
Regards,
Arjen
2006/10/16, David_S_Green@dell.com David_S_Green@dell.com:
I've triple checked that I am using the correct database password. Is there somewhere in MySQL I need to check?
Dave
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Arthur Guy Sent: Monday, October 16, 2006 11:29 AM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Can't configure multiple Wikis?
Surely this is just a database permissions error. Have a look at what tables the user wikiuser has access to.
Arthur
arthur@assys.net
From: mediawiki-l-bounces@Wikimedia.org on behalf of David_S_Green@Dell.com Sent: Mon 16/10/2006 17:13 To: mediawiki-l@Wikimedia.org Subject: [Mediawiki-l] Can't configure multiple Wikis?
"CREATE command denied to user 'wikiuser'@'localhost' for table 'gec_user' (localhost)".
It will let me setup a new wiki without using the prefix, but then that shares the original wiki's data....and that isn't what I need to do.
Appreciate any help I can get.
Thanks, Dave
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
2006/10/16, David_S_Green@dell.com David_S_Green@dell.com:
I've triple checked that I am using the correct database password. Is there somewhere in MySQL I need to check?
"CREATE command denied to user 'wikiuser'@'localhost' for table 'gec_user' (localhost)".
Even though 'wikiuser' can access the database for selects, etc, it would seem that it does not have access to create tables. It works without a table prefix since the tables already exist... nothing new to create.
Start here: http://dev.mysql.com/doc/refman/4.1/en/privileges-provided.html
Dan
mediawiki-l@lists.wikimedia.org