Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » Index command denied (Table created, but I'm stucked in the installer)
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Index command denied [message #161425] Tue, 22 December 2009 17:17 Go to next message
Underdog is currently offline  Underdog   Denmark
Messages: 3
Registered: December 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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?
Re: Index command denied [message #161427 is a reply to message #161425] Tue, 22 December 2009 23:00 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Core Developer
remove from buddy list
ignore all messages by this user
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';

Or even better, GRANT ALL PRIVILEGES ON *.* TO...
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: InnoDB instead of MyISAM
Next Topic: SQL Optimization
Goto Forum:

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 18 13:48:49 EDT 2021

Total time taken to generate the page: 0.00630 seconds