FUDforum
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 :: Show 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?

Report message to a moderator

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: 3712
Registered: December 2004
Karma: 26
Senior Member
Administrator
Core Developer
 add to 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';
FLUSH PRIVILEGES;


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

Report message to a moderator

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: Fri Feb 28 19:58:35 EST 2020

Total time taken to generate the page: 0.00778 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.8.
Copyright ©2001-2018 FUDforum Bulletin Board Software