Sounds like your MYSQL privileges aren't set properly. Can you connect to and alter your database through the MYSQL consol?
First of all though, double check your advanced data source details in CF administrator. Make sure Allowed SQL is set properly. Check your user, host and privileges tables in MYSQL. Or try creating a fresh user with ... GRANT ALL PRIVILEGES ON *.* TO 'user' @'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; flush privileges after change update data source in CF If that doesn't work stop and restart CF and mysql. I had this problem some time ago and ended up removing the coldfusion user from all the privilege and host tables. Basically started afresh. Regards, Angus Last thought check the user that MYSQL us running under. Was it a standard install? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo Russon Sent: Monday, 30 August 2004 3:29 PM To: CFAussie Mailing List Subject: [cfaussie] OT: MySQL Table Permissions. Hey Guys.. Since i moved my database from my windows dev machine to our new redhat server, i am getting an error. Error Executing Database Query. General error: Table 'table_name' is read only From my google-ing i have found various things about file and folder permissions. I've tried changing all the files and folders to Read / Write / Exec, but its not helping at all. The user i have created for the database has been granted all privileges. Does anyone know what i am doing wrong? TIA, Ricardo, --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
