What version of CF are you using? It sounds like pre-MX. The procedure you describe is for pre-MX boxes (the one where you make an odbc dsn outside of CF in the cpanel applet).
You can see things in mySQLFront because it doesn't care about ODBC. Its querying the mySQL db directly. You can use the username of 'root' with no password on a default install when making your odbc connection. Thats the default user. Certainly not something you want to leave on a live box, so don't forget to set up a user with proper permissions before going live! I personally prefer creating the user and pwd in mySQLFront, then going into the table itself and granting/denying each permission from within the table itself. ------------------------------------------- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ------------------------------------------- ---------- Original Message ---------------------------------- From: "FlashGuy" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Wed, 22 Jan 2003 12:07:25 -0500 >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
