on 8/2/01 9:55 AM, Chris Malloch at [EMAIL PROTECTED] wrote:
> Hi people with far more knowledge than myself,
>
> I have recently started making use of MySQL on a virtual server provided by
> my ISP. I can telnet into the server using SSH Telnet, log in to my
> database, create tables and populate those tables. When I try to alter the
> field definitions of a table however, I get the following message -
>
> Access denied for user: '[EMAIL PROTECTED]' to database 'chrisdb'
>
> The query used to add some fields to an already created table called
> "question" is as follows -
>
> ALTER TABLE question ADD NumberOfStaff VARCHAR (20) , ADD PortfolioProducts
> TEXT , ADD PortfolioClients TEXT , ADD AdditionalInfo TEXT
it appears that your isp needs to turn on 'alter_priv' permission for user
'[EMAIL PROTECTED]' on database 'chrisdb'. it's odd that they turned on
create and insert but not alter.
one solution you can use is to dump the table to a file
mysqldump --add-drop-table chrisdb question > somefile.dump
then edit the file and use it to reload the table
mysql chrisdb < somefile.dump
(these examples work on unix, ymmv)
hope this helps,
mike
-- mike cullerton
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
