Re: read-only tables

2001-02-01 Thread Jeremy D. Zawodny
On Fri, Feb 02, 2001 at 12:11:07AM -0800, Matthew Halliday wrote: > > I have a database that I finally got connected to my newly installed > MySQL, I've had a bad week, however I can't add information to the > tables, it says they are read only! How can I fix this? I've check > the manual but I a

Re: read-only tables

2001-02-01 Thread Danny
Hello Thats probably you username in user table has given you only SELECT prilvages (Select_priv) You can log in as root in mysql and UPDATE the user table to give you INSERT, DELETE privlages Refer to any sql book on the syntax of UPDATE On Fri, 02 Feb 2001, Matthew Halliday wrote: > I have