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 > 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? ----- Excess quoted text cut - see Original Post for more -----

> 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 ----- Excess quoted text cut - see Original Post for more -----

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. ----- Excess quoted text cut - see Original Post for more -----

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. :-] ----- Excess quoted text cut - see Original Post for more -----

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 > 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

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... > 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... > 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 > 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 ----- Excess quoted text cut - see Original Post for more -----

> 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 :-) > 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 > >