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

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:

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

[Message index]

		Index command denied By: Underdog on Tue, 22 December 2009 22:17
		Re: Index command denied By: naudefj on Wed, 23 December 2009 04:00

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 02:27:47 GMT 2024

Total time taken to generate the page: 0.06865 seconds