webserver (sorta)

[Far]

i want to have a little site which can support php and mysql, and i want to run it from my pc.

all it is, is a simple account registration page for a game, but i only want it to b up when my pc is switched on.

no need for a domain address yet, can i jus run it off my ip?

how would i go about setting up this from my pc?
and what programs would i need.

 

[hellcaster]

EasyPHP from here

or WAMP from here

right which ever one you decide to download, you put your php page files in the WWW directory, so for WAMP it'll be C:/Wamp/WWW and for EasyPHP
C:/program files/EasyPHP/Appache/WWW i think im not soo sure, then if you put it offline you type in your address bar http://127.0.0.1 or if you want it online, if your using WAMP it does it automatically for you, if your using EasyPHP, you have to do it your self, so you'd go into C:/program files/EasyPHP/Appache, then i think it was httpd then search for 127.0.0.1:80
and replace 127.0.0.1 with your ip, if your on router er, you find 127.0.0.1( i think ) abit further down the page and put your router ip there and your global ip in the top one it should be 77.98.27.92:80 w.e your global ip is and then on the bottom one 192.168.2.2 or w.e your router ip is

i know i havent explained it the best xD but if you need anymore help ask me on msn [email protected] and ummm, i hope it helps you XDD

best of luck mate (Y)

 

[mythonline]

i highly suggest xampp lite, fast install, and till now i never had problems with it.

 

[hellcaster]

personally, i dont like xamp, its probz just me, but as far as i know u cant minize it to the system tray, which for me annoys me XD but yeah xamp is good too

 

[Far]

thanks, ive downloaded easy php, and my page is running on 127.0.0.1, but..

since easy php uses apache and mysql, i cant run both mysql's at the same time

one for the easyphp
one for the servers database

if either is down, then it wont read the database

im not all up on how mysql and ports work. so is there a way i can get both mysql's running and working at the same time?

if my server mysql is running, and easyphp isnt, i get this written on my webpage.

"Error: Unable to connect to MySQL server. MySQL reported: Client does not support authentication protocol requested by server; consider upgrading MySQL client."

if easyphp mysql is running, and my server mysql isnt i get this message.

"Error: Unable to connect to MySQL server. MySQL reported: Access denied for user 'root'@'localhost' (using password: YES). "

 

[Zion-Servers]

Best way to do it, is to get an all in one web server that has it all incorporated. Theres one that is really good that ive used on the past for both php and mysql. Will post the links later when it comes back to me what it was.

 

[Far]

i dont want to get rid of mysql using my servers databases, it takes hours to import the databases.

 

[hallmat]

Cant you just have the web site running off a diff part of the Mysql so leave the game's db's and just make another db for your website like this


this is for mir

Account (Mir)
Conlog(mir)
CruelDragon3GBaseData(mir)
Hero3G(mir)
Game3G(Mir)
Manage(mir)
Website (your website DB here)
Php DB

can you not have it like that?? it will all be running no need to open any more ports cose if u using Mysql then you should have opend the port anyway

and here is a link to set it all up with some usefull information

http://www.php-mysql-tutorial.com/

Hope this helps m8

 

[Far]

no because its an account creation page. which means account table has to be edited.

anyway. i found a guide, all i needed to do was allow privileges through phpmyadmin, and then reimport my databases into another mysql folder.

thanks for the help.

 

[Hazuki]

Easy lol install mysql twice, but using different ports, then tell each app the new port.

 

[hellcaster]

Easy lol install mysql twice, but using different ports, then tell each app the new port.

yep this should work, i think u might have to use 2 different users aswell?

also cant u use MSSQL for ur databases :P ?

 

[Hazuki]

No you could use the same username, aslong as each software allows you to specify the mysql port.

 

[Far]

using wamp now. and have just disabled wamps mysql. seems to be working fine now.

 

[Dataforce]

Why on earth would anyone suggest to install it twice o.0

 

[Hazuki]

I have mysql and php installed twice DF ^^

 

[Far]

i need it installed twice. although the one the comes with easyphp is disabled, i have to have the original mysql 5.0 loaded, otherwise it wont let me connect with navicat (since easyphp mysql doesnt ask to setup a password)

 

[Dataforce]

There is no sane reasonf or having it installed twice. its a service daemon, its not MENT to be installed twice, once is all thats needed.

I do believe in c:\program files\mysql\bin or so there will be a WinMySQLAdmin.exe or something, that lets you set the root password.

if navicat won't let you connect to a passworded server, its ****.