Make sure that you have done a GRANT statement on the database to the login (TO clause) correct IP address (@ clause) and password (IDENTIFIED BY clause) in MySQL, followed by a restart or a mysqladmin -p reload
The @ clause can be tricky... it has to be the one that MySQL is seeing, which might be localhost or some other alias, depending on the machine. Don't use a canonical name...you don't want to pay the performance hit of a DNS lookup. This WILL work, it's just a matter of getting everyone agreeing on who and from where. We do it all the time, and end up screwing it up about 1 in 5 times :-) Greg At 12:11 PM 3/8/2003 -0600, samcfug wrote: >I had a similar problem, and it turned out to be the "login as" user ID and >password having a typo. Also uncheck the "keep connection alive" > >===================================== >Douglas White >group Manager >mailto:[EMAIL PROTECTED] >http://www.samcfug.org >===================================== >----- Original Message ----- >From: "FlashGuy" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, January 22, 2003 11:07 AM >Subject: CF and MySQL > > >| Hi, >| >| I've installed MySQL. I can't seem to verify the databases within the CF >Adminstrator. I created the data source within the System DSN. I then go into >the CF >| Admin and try to verify the database but it fails. >| >| I've also installed MyODBC for MySQL >| >| Why? >| >| I cant see the database with MySQL-Front no problem. >| >| >| --------------------------------------------------- >| Colonel Nathan R. Jessop >| Commanding Officer >| Marine Ground Forces >| Guatanamo Bay, Cuba >| --------------------------------------------------- >| >| >| >| > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
