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