Guys, thanks for all the suggestions. I actually did what Brett mentioned and it worked. I used the IP address of the box, which worked. Yet localhost did not. Any reasons for this?
Thanks, Dennis -----Original Message----- From: Brett Schlank [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 3:47 PM To: CF-Linux Subject: RE: CF MX/RH 7.3/MySQL Hi, mySQL has problems using 'localhost' in connection parameters on some platforms/db drivers for a variety of reasons (dns, streams vs sockets, etc). Have you tried to use the IP of the box or '127.0.0.1' for the loopback instead of 'localhost' in your connection parameters? -- Brett At 12:19 PM 7/14/2002 -0400, Jonothon Ortiz \(Xnext, Inc\) wrote: >try to explicitly set user@localhost -> if the user is accessing the records >on the same machine then mysql will recognize him as user@localhost; adding >user@% can be a problem. Always try to explicitly declare the host of the >user. > >Also check your CFADMIN settings and see if you've got a limit on any SQL >commands. A normal user should be > >GRANT SELECT, INSERT, DELETE, UPDATE, DROP ON TABLE.* TO 'user@localhost' >IDENTIFIED BY 'Password'; > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
