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

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



---------------------------------------------------------------------
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

Reply via email to