If you look at the users in MySQL... by default, root can connect from localhost and @% <--- @% means ANYWHERE! (Remove root@% and only use root@localhost).
So, example grant statement: grant insert, update, delete, select on mydatabase.* to todd@'192.168.0.5' identified by 'somePassw0rd12' This means that ... the user 'todd' can only connect from 192.168.0.5 and it todd tries to connect from any other address other than that (even if the password is successful) it'll fail. ~Todd At 08:53 AM 6/22/2002 -0700, you wrote: >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 > >-----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
