Thanks for the help.
I found that after i restarted the MySQL server a few times, and finally making it create its mysql.sock when it started, got it to work.
Why you would have so many ways to start a server if only one way works is beyond me.
Ricardo.
Angus Johnson wrote:
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/
