Ah yea sorry. I was assuming that your database was already created and you could just enter the db name into the code.
Glad you got it to work! Mike ----- Original Message ----- From: "Jean-Charles Carelli" <[EMAIL PROTECTED]> To: "CF-Newbie" <[EMAIL PROTECTED]> Sent: Thursday, November 11, 2004 1:33 PM Subject: Re: registering mySQL with CFMX 6.1 > Dear Mike and Stephen, I got it to work! > > 1. CF accepted my DSN once I set the user domain to any domain ie; > > mysql> GRANT ALL PRIVILEGES ON *.* TO user@"%" IDENTIFIED BY 'password' > WITH GRANT OPTION; > > > 2. I tried both of your code samples. I was not able to get Mike's > to work. The error stated that the database did not exist.. I was > about to create a DB manually when I received Stephen's code and gave > that a crack. It worked! > > This is the output in my browser window: > test - test - test - no > > This is the URL of the test: > http://porterandwhite.com/CFMService/testMySQL_2.cfm > > > I can assume that because CF accepted my DSN and the CFM I tested seems > to work that I now have access to MySQL via CF. Are there any follow > up tests or best practices I should employ? > > Is the GRANT statement I used too all-encompassing? > > I hope I can learn this stuff fast enough to help others the way you > have helped me. > > My very best regards, > > Jean-Charles Carelli > > > PS: What is the variable 'AdminContent' ? I can follow the rest of > your code but I'm puzzled by that part? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:15:475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
