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