FUDforum: Database discussions » Index command denied

Home » General » Database discussions » Index command denied (Table created, but I'm stucked in the installer)

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

Index command denied [message #161425]

Tue, 22 December 2009 22:17

Underdog

Messages: 3
Registered: December 2009

Karma: 0

Junior Member

Well I made it all the way to the last point. Then I got this line (in the database section of the installer):

Failed to create table "fud_forum_notify" ("CREATE UNIQUE INDEX fud30_forum_notify_i_uf ON fud30_forum_notify (user_id,forum_id)"), SQL Reason: INDEX command denied to user 'web58'@'localhost' for table 'fud30_forum_notify'

Maybe something with my permission rights, but what I don't understand is why the table is created and the installer return this "error"? Is it a bug??? How can I get around this?

Report message to a moderator

Re: Index command denied [message #161427 is a reply to message #161425]

Wed, 23 December 2009 04:00

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Looks like your MySQL user was granted permission to create tables, but not indexes. You may need to contact your hosting provider to grant you access.

% mysql -u root mysql
GRANT INDEX ON fuddb.* TO web58'@'localhost';
FLUSH PRIVILEGES;

Or even better, GRANT ALL PRIVILEGES ON *.* TO...

Report message to a moderator

Previous Topic:	InnoDB instead of MyISAM
Next Topic:	SQL Optimization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 15:52:47 GMT 2024

Total time taken to generate the page: 0.02741 seconds