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 :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic

Index command denied [message #161425]

Tue, 22 December 2009 17:17

Underdog

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

Rate author: +1 -1

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

Tue, 22 December 2009 23:00

naudefj

Messages: 3757
Registered: December 2004

Karma: 27

Senior Member
Administrator
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';
FLUSH PRIVILEGES;

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

Report message to a moderator

Rate author: +1 -1

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 20 00:45:39 EDT 2021

Total time taken to generate the page: 0.00648 seconds