shawngibson Posted December 12, 2006 Share Posted December 12, 2006 Hi Everyone, after several years of Flash/PHP using Apache2Triad bundles, I've decided to take the plunge into Flex/ColdFusion MX 7.0.2 through Apache webserver with a MySQL db. I'm halfway through the "ACME" instructions (http://www.acidlabs.org/extras/acme/), but having never had to install MySQL or Apache before (from scratch), I don't know what the proper info should be for the "://[host]:[port]/[database] " part of instructions (6) in this page, which I have to do apparently:http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=6ef0253I followed the instructions from ACME perfectly, MySQL starts fine, so does Apache, so does CF and so does Eclipse...I don't have any databases yet, nor should I if following the ACME Guide start to finish is correct. I'm at the step to make MySQL and CF communicate. I recall the port was 3306 (I think).In apache I have localhost and 3 virtual hosts:shawngibson.comcounterchaos.comfaceitphoto.ca...all set to 127.0.0.1 (yes, they give me errors since nothing is there yet but it doesn't stop any services, and the Guide says this is normal) in the hosts page. I can see CF, and Apache externally via the web.So all is going good, but I have absolutely no idea what to plug in for jdbc:mysql://[host]:[port]/[database] ...after the :// Could someone offer a noobie some help on this? The ACME author has done a fantastic job, so I would be shocked if at this point he asks us to do something without full disclosure (i.e., make sure you have a database before you go any further...).Also, I am assuming I can install PHP5 and PHPmyAdmin...after I'm done, is that correct? One of my sites is Flash/PHP, the other...dunno yet, and the other CF/Flex (hopefully!) all from my server at home...Thanks very much:)Shawn Quote Link to comment https://forums.phpfreaks.com/topic/30288-real-dork-just-installed-mysql-what-is-jdbcmysqlhostportdatabase/ Share on other sites More sharing options...
btherl Posted December 12, 2006 Share Posted December 12, 2006 Host is probably 127.0.0.1, and port you should leave blank if possible. 3306 is the default.For database, that will be whatever name you used when you created your database. If you haven't created your database yet, go back into mysql and do it :) A single copy of mysql can have several "databases" running inside it, each with different names. Quote Link to comment https://forums.phpfreaks.com/topic/30288-real-dork-just-installed-mysql-what-is-jdbcmysqlhostportdatabase/#findComment-139442 Share on other sites More sharing options...
shawngibson Posted December 12, 2006 Author Share Posted December 12, 2006 Awesome, thanks. I've only ever created db's in phpMyAdmin. If I grab say an SQL text file that creates/populates a db with a few tables, usually populated into phpMyAdmin directly via .sql file, can I do the same in the MySQL Command Line Client?Shawn:) Quote Link to comment https://forums.phpfreaks.com/topic/30288-real-dork-just-installed-mysql-what-is-jdbcmysqlhostportdatabase/#findComment-139448 Share on other sites More sharing options...
shawngibson Posted December 12, 2006 Author Share Posted December 12, 2006 Worked like a charm, i create database counterchaos, and use that, no port, and it shows up in CF admin with a status of OK.Thanks very much for your help:)Shawnps still curious to know if I can run PHP and CF on the same webserver, if anyone knows...? Quote Link to comment https://forums.phpfreaks.com/topic/30288-real-dork-just-installed-mysql-what-is-jdbcmysqlhostportdatabase/#findComment-139575 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.