Michael, You're a Windows user, right? The following only applies to Win.
In and of itself mySQL doesn't come with a front end. Probably the best 3rd-party gui is at http://mysqlfront.de. You will be able to do anything you want with this, most likely. To install mySQL on your server download the windows executable from http://mysql.com/downloads/index.html. Note that v4.0 is still classed as an alpha despite its being plastered all over their site. I'd suggest downloading 3.23.48 for this reason alone. While you're there download myODBC so you can set up your datasources. The new v3.51 is classed as 'developmental', although you have to dig to see that label. Use either it or v2.5 depending on the feature set you need (v2.5 should be fine for almost anything you can throw at it with CF). Note they can coexist on the same server so you can install both if you like. Then run the installer for mySQL. When its done run the appropriate mySQL executable file. Probably mysqld-nt.exe. This will set it up as an automatic service. Then install myODBC. Get rid of their admin utility if it wants to install itself in the system tray. When both are in place you need to set up your dsn's. Since CF doesn't natively support mySQL you'll need to install your datasources manually with the Windows Datasources control panel applet (Settings/Control Panel/Administrative Tools/Data Sources). CF will be able to see them automatically once you do this. Set them up as System dsn's So much for setup. To use the thing you can use either CF and SQL to manage your tables or the graphical front end I mentioned earlier. A lot of times its faster just to create a Create Table template than wade thru a gui, but that's up to you. Cheers, --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 09, 2002 9:46 AM To: CF-Talk Subject: CF and MySQL Hello. I am never used MySQL before but have been asked to do a project using CF and MySQL. Does MySQL have in interface similar to SQL Server to use? how to you go about creating the DB.. do you have to use SQL statements to generate the DB? Can anyone offer a quick rundown of how MySQL works or perhaps point me to some websites? TIA, Mike ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
