mySql question?

When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug

phpmyadmin Doug Brown wrote: > When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? > > > > Doug > >

ok, I saw where this is available. Is anyone here using mySql with CF? Is there a way to connect to mySql with CF natively? I am using CF5 Thanks again ----- Original Message ----- From: "Jake Churchill" <jake@cfwebtools.com> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, September 07, 2006 1:16 PM Subject: Re: mySql question? > phpmyadmin > > Doug Brown wrote: > > When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface?

> phpmyadmin ahh yes the ugly and klunky as sin and a PITA to secure too...great tool ;-) just yesterday found a wide open copy with client data easily changed and/or exported...a true testament to it's greatness yes..I'm done now ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: bryan@electricedgesystems.com web: www.electricedgesystems.com

Navicat rocks - does that and a whole lot more.  Pretty damn cheap too. > > When mySql first came out, if memory serves me correctly it only had a command > line interface. Has things changed with it? Are you able to create tables etc from > a GUI interface? > > > > Doug > >

+1 for Navicat.  Best $99 I ever spent for software, I would pay much more. Has saved me uncountable hours of work.  Plus, 30 day free trial. http://www.navicat.com -- Josh ----- Original Message ----- From: "Ray Champagne" <raychampagne@gmail.com> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, September 07, 2006 12:19 PM Subject: RE: mySql question?

Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See http://dev.mysql.com/downloads/gui-tools/5.0.html. --- Ben When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug

Hey Ben, nice of you to chime in also. I looked at navicat and it truly does seem pretty darn cool. Has anyone had any experience with the developer version they are working on? It seems to me that Navicat has a few more features. ----- Original Message ----- From: "Ben Forta" <ben@forta.com> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, September 07, 2006 1:19 PM Subject: RE: mySql question?

Ben... Can the GUI tools connect from your desktop to a remote database? <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. andy@icglink.com 615.370.1530 x737 --------------//---------> Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See http://dev.mysql.com/downloads/gui-tools/5.0.html. --- Ben When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug

Sure can. Actually, it always does. You define a server using hostname/ip address, port, user login, and password. If you specify localhost as the hostname then it is local. --- Ben Ben... Can the GUI tools connect from your desktop to a remote database? <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. andy@icglink.com 615.370.1530 x737 --------------//---------> Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See http://dev.mysql.com/downloads/gui-tools/5.0.html. --- Ben When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug

Very nice. I'll have to give them a look. Thank you. <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. andy@icglink.com 615.370.1530 x737 --------------//---------> Sure can. Actually, it always does. You define a server using hostname/ip address, port, user login, and password. If you specify localhost as the hostname then it is local. --- Ben Ben... Can the GUI tools connect from your desktop to a remote database? <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. andy@icglink.com 615.370.1530 x737 --------------//---------> Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See http://dev.mysql.com/downloads/gui-tools/5.0.html. --- Ben When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug

Late reply, but plus one for navicat.  Great bit of software, and regularly updated. (they were supporting some of the mysql5 stuff /way/ before I started using it.  That's sweet.) I thought I'd ditch it when I went Eclipse pluginztyles, but hellz no, I still fire that sucker up. Loads quick too. :-] On 9/7/06, Andy Matthews <andy@icglink.com> wrote:

It has both. If you have access to the command line you can work with that. I'd say though that most people use a GUI. PHPMyAdmin is very popular, as is MySQL Front. <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. andy@icglink.com 615.370.1530 x737 --------------//---------> When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug

Doug Brown wrote: > When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? > There are many desktop and web based GUI interfaces to MySQL these days. One of my favorites... http://www.aquafold.com/ (which also works with most other dbs) and the "official" ones... http://www.mysql.com/products/tools/administrator/ http://www.mysql.com/products/tools/query-browser/

mySQL 5 has GUI tools available: http://dev.mysql.com/downloads/gui-tools/5.0.html create > tables etc from a GUI interface? > > > > Doug > >

Yep...have a look at Navicat....nice tool Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: bryan@electricedgesystems.com web: www.electricedgesystems.com

Who was in this in response to Bryan? <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. andy@icglink.com 615.370.1530 x737 --------------//---------> Yep...have a look at Navicat....nice tool Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: bryan@electricedgesystems.com web: www.electricedgesystems.com

> Who was in this in response to Bryan? To Doug the original poster....why? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: bryan@electricedgesystems.com web: www.electricedgesystems.com

Just checking. I had asked a question as well. Wasn't sure if you were answering mine. <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. andy@icglink.com 615.370.1530 x737 --------------//---------> > Who was in this in response to Bryan? To Doug the original poster....why? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: bryan@electricedgesystems.com web: www.electricedgesystems.com

Navicat is my fav. It rocks! www.navicat.com Will

So how is the support for mySql and Coldfusion? Version 5... ----- Original Message ----- From: "Will Tomlinson" <mhwd@bellsouth.net> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, September 07, 2006 1:18 PM Subject: Re: mySql question? > Navicat is my fav. It rocks! > > www.navicat.com > > Will > >

No MySQL 4 or 5 drivers included with ColdFusion now because of licensing issues. You can use the older driver, or download a newer driver and install it manually. As for "Scorpio", well, er, um, ah, I can't say (yet)! <evil grin> --- Ben So how is the support for mySql and Coldfusion? Version 5... ----- Original Message ----- From: "Will Tomlinson" <mhwd@bellsouth.net> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, September 07, 2006 1:18 PM Subject: Re: mySql question? > Navicat is my fav. It rocks! > > www.navicat.com > > Will > >

Ok as far as drivers for mySql for use with CF. Where do you find them at? Doug ----- Original Message ----- From: "Ben Forta" <ben@forta.com> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, September 07, 2006 1:53 PM Subject: RE: mySql question? > No MySQL 4 or 5 drivers included with ColdFusion now because of licensing > issues. You can use the older driver, or download a newer driver and install

> So how is the support for mySql and Coldfusion? Version 5... Sorry Doug...need clarification ;-) How is the support from where? from NaviCat for mySQL? from Adobe for mySQL and CF? other? version 5 of what? mySQL? or CF? or both? Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: bryan@electricedgesystems.com web: www.electricedgesystems.com4

Doug Brown wrote: > When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Yes, see www.mysql.com for details ;)

funny...funny...funny...As I stated right after I sent the "original" email, I finally found it on their jumbled up mess of a site. But thanks for the info :-) ----- Original Message ----- From: "Rick Root" <rick.root@webworksllc.com> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, September 07, 2006 2:06 PM Subject: Re: mySql question? > Doug Brown wrote: > > When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? > > > Yes, see www.mysql.com for details ;) > >

+100000 Navicat rocks - does that and a whole lot more.  Pretty damn cheap too. > > When mySql first came out, if memory serves me correctly it only had a command > line interface. Has things changed with it? Are you able to create > tables etc from > a GUI interface? > > > > Doug > >