WampServer

to create the database table by using SQlyog

They're in mysql folder, but you can't just directly edit them but through either mysql console or phpmyadmin. For personal use, I've created a simple script to do just that; you can do so, too as long as your script is saved in www folder so php can detect it and parse it to mysql. Hope it makes sense to you.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

SQlyog is good but it might not be for newbies, just use phpmyadmin which already comes w/ wamp.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

now i have unstall the wamp from my computer , can i have the sql script that u created

Firstly, I don't understand why you uninstalled wamp. Did I say something wrong that made you misunderstood?

Second, my script only works w/ this wamp and might be also w/ wampMSS, but not w/ any other wamp package such as xamp, easyphp. so on...

Third, this script is for my personal use which includes my personal server info, settings, so on, so if you want it, I need to modify it and it might take a little while, and honestly, I really don't want to give you hope because recently, I've mentioned about easy tutor for setting up server built on wamp and until now I still didn't finish it; therefore, some people really mad at me for that. However, everyone has personal things they have to do for their life; hope you understand what I mean.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)



Post Edited (02-19-07 19:26)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

ok i understood

now my problem is iam not using any softwares like wamp anymore and i have configure apache,php,mysql manually , its seems to work fine only the php files but not connecting to mysql that i dont know why? , and i dont know how to run the developted phpmysql systems ..............i thing first we have to create the database and tables in the mysql using the sql dump script then we have to manually change the host,username,password,database in the config.ini.php is that the way? (in local machine)

I think I've got your problem now.

he... he... ;-)

You installed everything separately; php works but didn't parse to mysql as expected, so you tried wamp, still DIDN'T WORK THE WAY YOU THINK, that's why your uninstalled wamp; it's not you misunderstood from something I said, RIGHT?

he... he... ;-)

I've never install them separately, so I'm not quite sure about that, just guess it depends on how you setup the primary document root. For example, it's www folder in wamp.

As mentioned above, IT DIDN'T WORK THE WAY YOU THINK, but when you save your scripts in the right folder (i.e. www in wamp), php will auto parse the script to mysql if having the right log in info. For example, if you trying the testing code in my signature, all php scripts for that site (i.e. test.jlbn.com) are saved in wamp/www/test and cgi scripts are in wamp/www/test/cgi-bin, not in any other mysql folder as you think, the scripts will auto parse the code to mysql w/ db "test". Similarly, all scripts for phpbb2 (i.e. forum.jlbn.com) are in wamp/www/phpbb2 and php still parse the codes to the same mysql but, of course, w/ different db "phpbb2". Hope this make sense to you.

So, if you still want to keep yours, you have to setup primary document root properly, but if you want to get help from this forum, you should use wamp since most people might not know what you're talking about when you have a problem.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

these 5 days i got offline from internet.....

i have edited the php.ini document root to C:\webs\test

ok if you are guiding or helping from start to get my php systems to work on my localhost i will install the wamp right now and unstall php , mysql, apache softwares from my machine

I'm not sure where're you from, but in US nowadays hard drive is very cheap. For example, 250GB external for $30 AR+CP at OfficeDepot, 200GB internal for $10 at Staples, so if you happen don't have a spare hd around, you'd better get a new hd instead re-format your current one. If you don't want to buy a new hd, better backup all your data to somewhere else safe and re-format your current hd. If you can't re-format hd, after uninstall all apache, mysql, and php, search and delete all related apache, mysql, php, wampapache, wampmysql in WINDOWS AND REGISTRY.

With new or re-format hd, install only 3 applications that are Windows, AntiVirus+Firewall , and WAMP. For AntiVirus+Firewall, suggest to use McAfee Internet Security Suite instead Norton, ZoneAlarm, so on; right now that suite is free AR at Staples. Then, come back here when you're ready.

Remember, DON'T EDIT ANYTHING because IT WILL NOT WORK THE WAY YOU THINK. For example, except adding VirtualHost for all my sub domains, I didn't change anything in config files including php.ini. If you're not sure what you're doing, the more you change the more headache you would have.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

ok i have not format the HD but i have completely remove apache,php,mysql and i have installed the Norton Internet Security 2007 and Wamp

Quote

With new or re-format hd, install only 3 applications that are Windows, AntiVirus+Firewall , and WAMP.

Quote

ok i have not format the HD but i have completely remove apache,php,mysql and i have installed the Norton Internet Security 2007 and Wamp

You see something different here. Do you know why I suggest to get new or re-format hd, because I can NOT see what in your computer might lock wamp function properly. Another thing, Norton is not a good choice because I see a lot of people here have problem w/ Norton and wamp. So make sure to do so before proceed to the next step.

After installing wamp and all add-on, immediately save the whole wamp folder to somewhere safe even though you did NOT store any data yet because it save you a lot of time for you if accidentally have any mistake.

[forum.wampserver.com]

Anyway, check to make sure both services running; then, check my old post from the link above and ONLY do these setup:

1. Enable port 80 in Antivirus and all firewalls. Also forward port 80 in router if using router.

2. Setup password for "root" and DO NOT create any database yet.

Come back here after you're done and ready.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

ok i have reinstalled windows, wamp,ZoneAlarm

Ok, it seems you never mention about ZoneAlarm and it's your real problem so can you use anything else than ZoneAlarm? Suggest to get McAfee Internet Suite which is free AR at Staples right now.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

before i have install ZoneAlarm with your suggetion but i dont understand why mentioned to remove the ZoneAlarm in the above post,ok now i have uninstaled the ZoneAlarm and installed McAfee Internet Suite . what next

Firstly, I've never suggested ZoneAlarm to anyone, but Antivirus+Firewall.

Second, make sure all services running and you can access these:

[locahost]

[locahost]

If yes, then check my old post through the link provided before and setup password for "root", then come back here when ready

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

the root password setup is done and only windows port 80 could added but in the 3-party firewall having problem (i dont understand how to enable the port), and having trouble in Enabling port forward in router

So did you able to access localhost and phpadmin or not?

What kind of router are using? Remember to include the model number.

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)

Actually, if you run your server local only, you don't need to do port forward, but do need to enable port 80 in firewalls

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)
[wp.jlbn.com] (testing WordPress 2.1)
[ws.jlbn.com] (testing WebSpell 4.01.02)



Post Edited (02-26-07 19:49)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

yes i want to run the system locally. after creating password to root in the phpmyadmin the [localhost] is not working , its retaining a error msg "#1045 - Access denied for user 'root'@'localhost' (using password: NO)"

only i have to test in local