List:General Discussion« Previous MessageNext Message »
From:Chris Malloch Date:August 2 2001 3:55pm
Subject:ALTER TABLE question
View as plain text  
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: 'chris@stripped' 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

Whether I use the command line to write the query, or a front end such as
MySQLFront (which, incidentally, I think is great!!) or even using
phpMyAdmin I still get the same response.

Anyone with any ideas as to why this should be the case?

All help greatly appreciated in advance :-)

Regards,

Chris


Thread
Host Access deniedMike2 Aug
  • Re: Host Access deniedSherwin Ang2 Aug
  • ALTER TABLE questionChris Malloch2 Aug
    • Re: ALTER TABLE questionmike cullerton3 Aug
    • Re: ALTER TABLE questionStefan Hinz3 Aug
Re: Host Access deniedMike2 Aug