Gossamer Forum
(Advanced Search)
for
Jan 3, 2001, 2:03 PM
devbite
Novice (38 posts)
Jan 3, 2001, 2:03 PM
Post #1 of 3
Views: 2854
Shortcut
Quote Reply
SQL help
I've just tried to add a new field called Short_Description, but when I did the following error came up:-

Database Error: Unable to execute query: ALTER TABLE Links ADD Short_Description CHAR(100) . Reason: alter command denied to user: 'devbite@localhost' for table 'Links' alter command denied to user: 'devbite@localhost' for table 'Links'

I wasn't to sure what this error means. Can anyone help?

Thanks

James

Jan 3, 2001, 7:48 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Jan 3, 2001, 7:48 PM
Post #2 of 3
Views: 2782
Shortcut
Quote Reply
Re: SQL help In reply to
Looks like you do not have proper permissions to ALTER tables within your MySQL database. Contact your sys admin.

Regards,

Eliot Lee
Jan 4, 2001, 1:16 AM
devbite
Novice (38 posts)
Jan 4, 2001, 1:16 AM
Post #3 of 3
Views: 2772
Shortcut
Quote Reply
Re: SQL help In reply to
Thanks, I have a dedicated server, do you know what do I need to do to change permissions in MySQL? (I'm quite new to MySQL)