FUDforum: FUDforum Installation Issues » Installation error in step 2: access denied when creating MySQL index

Home » FUDforum » FUDforum Installation Issues » Installation error in step 2: access denied when creating MySQL index

Show: Today's Messages :: Polls :: Message Navigator

Installation error in step 2: access denied when creating MySQL index [message #23762]

Mon, 28 March 2005 16:26

pozmu

Messages: 14
Registered: March 2005

Karma: 0

Junior Member

Hi
I'm trying to install Fudforum. At install step 2 I get error:

Failed to create table "fud_users" ("CREATE UNIQUE INDEX fudusers_i_l ON fudusers (login)"), SQL Reason: Access denied for user: 'pozmufud(at)10(dot)0(dot)2(dot)23' to database 'pozmufud'

This error is displayed in the "Database" row, just above the field where I enter DB name. MySQL version: 3.23.58-log. Fudforum version: I tried with FUDforum v2.6.12 and v2.6.12 Release Candidate #3.

I really don't know why such error occurs... What special privileges does "CREATE INDEX" require? I was not able to find anything about this in MySQL manual. I'm able to do:

ALTER TABLE fud26_users ADD UNIQUE INDEX fud26_users_i_l(login)

which, I believe, is the same command...

Report message to a moderator

Re: Installation error in step 2: access denied when creating MySQL index [message #23765 is a reply to message #23762]

Mon, 28 March 2005 16:36

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You need to have the "INDEX" permission that allows you to create & drop indexes.

FUDforum Core Developer

Report message to a moderator

Re: Installation error in step 2: access denied when creating MySQL index [message #23769 is a reply to message #23762]

Mon, 28 March 2005 16:47

pozmu

Messages: 14
Registered: March 2005

Karma: 0

Junior Member

Thank you, but are you sure that this is the problem? I'm able to create and delete indexes using Alter Table command, so don't you think that this is some problem with Fudforum? I will ask my host about this permission, but I found in manual that Create Index isn't real command, it's only alias to Alter Table. I will post when I get reply from my host.

Report message to a moderator

Re: Installation error in step 2: access denied when creating MySQL index [message #23771 is a reply to message #23769]

Mon, 28 March 2005 17:05

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

I am certain it is not a problem with the forum, since the query you've shown is perfectly valid and the error messages comes from MySQL and not the forum. So, that is where the problem lies.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	nntp.php and CPU utilization
Next Topic:	Upgrade prevents administering

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:30:23 GMT 2024

Total time taken to generate the page: 0.02651 seconds