Thanks. #1. I'm at the frustrated level of just testing locally, so I'm using root safely here. But you're right. I've been a very bad bear.
#2. user root already has all rights granted, but no specific rights to connect remotely. Is there one not listed in your example? Jon Krawczuk Applied Graphics Technologies DID 650-572-4115 CELL 650-996-8254 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 8:33 AM To: CF-Talk Subject: RE: MySQL and CF #1, why are you using mysql root to login? Bad Jon, no cookie. #2, use the grant statement to make yourself a real account. Make sure that you have permission from MySQL to connect from a remote machine. GRANT (PERM) on database.table to user@'ipaddress' identified by 'password' More documentation: http://www.mysql.com/doc/G/R/GRANT.html Try that and see if it works. MySQL is very picky about who can connect from what host (as it should be). It might be part of your problem. ~Todd On Sat, 22 Jun 2002, Jon Krawczuk wrote: > Yes that's what I mean. I can connect to this ODBC source outside of > CF5, but not through RDS > > Outside result: > > 'MySQL ODBC 3.51 Driver: 03.51.02 > DataSource 'home_contacts' Connected Successfully to 'mysqld-3.23.49' > !!! > OK' > > > But then get this trying to use RDS: > > 'Remote Server Operation Failure: > The connection with the server was reset > OK' > > > Near as I can tell the settings match those of the MySQL table I'm > connecting to. > I've doubled backed a dozen times, same result each time. > > Description: contacts > Host name:172.16.213.39 > Port: 3306 > > User Name: root > Password: > > Anyone seen a similar issue? > I am using Win2k professional connecting to a W2k server, CF5 Studio. > > Sorry for the double post, I included screen grabs in the first but they > were stripped out. > > Jon Krawczuk > -- ============================================================ Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator) | http://www.ultrashock.com/ - webRat (Back-end Moderator) | ============================================================ ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
