Try putting username root and a blank passed if you haven't set a root password for mysql
Shawn Tivnan ITS X2942 -----Original Message----- From: Nick Sweeney [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 10, 2007 10:59 AM To: CF-Newbie Subject: CF8 Connecting to MySql 5.1 Ok - here's a great Newb question! I have never setup CFAdministrator locally to connect to a MySQL DB. But, I got a new laptop and thought it would be a good idea to setup a "local testing environment on it." I have CF Server 8 - Developer installed I also have MySQL 5.1 installed - and I created a db with a table I go into the CF admin and try to connect - but nothing - so I think my settings are wrong? Datasource:bigfatty Server:bigfatty port: 3306 username: password: And I get the error "Connection verification failed for datasource: bigfatty blah blah Access Denied for user "@'localhost'(using password: NO)" I have no idea what I am doing.... In the past all databases were setup on the webserver by the hosting company. Thanks - Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3098 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
