I got a Question About PWS

I want to install Personal Web Server on my WinXP pc, but as Jayesh Jain said in his tutorial,

I think it isnt posible. But i still dont lose all hope, Is there a way for me to install PWS or Anyother way to test PHP on my PC?

Hi

Yes you cannot install Personal Web Server on Windows XP but you can install Microsoft IIS or Xitami Web Server and can test
PHP on these servers.

I have written article on devarticles.com to install IIS and Xitami.

Hope this Helps

Jayesh Jain

Thank you. Make sure I'll take a look to your tuts. ;-)

BTW, can i use Apache instead of Xitami or IIS?

or if you recomend me to use Xitami or IIS, i will do.

Thanks again.

Thank you very much, i tried Xitami, and it works very good, already configed all to make it work with php extentions.

But now i dont know how to make mySQL work I have all installed and the db are already done, but i they dont work.

I ran Xitami and mySQLadmin 1.4 at the same time, i dont know if by running those i should be able to have acces to db mSQL. or Do i have to setup somethings before.

Is there anything, tutorial, i can read?

According to apache's website, apache 1.3's requirements are a windows operating system with TCP/IP installed, it's runable on win9x so I would guess that you could run it on XP..

http://httpd.apache.org/docs/windows.html#req

as for getting mysql to work, I'm not sure.. I've only gotten it working on win2k.

Well, thx. But Xitami is running very well and i dont want to unistall it or change now thats it is working

But my problem now is that i cant acces to Database mySQL.

I tried running mySQLadmin and Xitami at the same time but i cant still have acces to database. I read that i got to install or create the database trhu "ODBC". I tried to run it and setup a SQL Server database but i got an error message, saying: "Error=SQL Error 14" ... Well if theres anything i can do, please tell me

Thanks to everyone

My tip is that you download MyODBC from mysql.com and install it (if you´re using Windows), and then try again and come back with your error message.

Thx, I did download myODBC and install the mySQL db, but... it isnt working.. i think it is a problem in the cofig of the db or something.... I kinda working on it, but if i dont know what to fix or config.. i wont be doing much... :-P thx again

Have you tried checking the Xitami website for any documentation on setting up MySQL? I'm not familiar with Xitami, as I run Apache on my server box, but I can't see why you shouldn't be able to run it with MySQL.

If nothing comes up on their site, send an email to their support and see what they say!

Hi Guys,

Sorry for not looking at this post before, but let me tell you few things , MySQL runs independent and not on web server, you can have Xitami,Apache or anything else dosnt matter.

So please install MySQL ( for windows) and make it running first. Ok here are few instruction mysql server does not start on its own so you will have to manually start mysql go to the bin folder in the mysql folder and run command

mysql-shareware start

or

mysql start

i think even running mysqld starts the server
there is also a mysql console exe file in the bin directory to
connect to the database and do some test queries.


Please do not download or install MyODBC those are the drivers which are required if you want to connect mysql with VB/Delphi etc, PHP has inbuild drivers for mysql - trust me you dont need any extra software to run mysql with php and you can vistually use any websever.

Hope this helps

Cheers
Jayesh Jain

Mail me on jainjayesh74@yahoo.com if you need more information

Hey, thank you it worked. At least i think so.

But i still got a problem

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'ejviper@IP-ADRESS' (Using password: YES) in C:\web\dbtest.php on line 17
Error: Couldn't connect to database

the line 17 of dbtest is :

$db = mysql_connect($dbhost, $dbuser, $dbpass) or die("Error: Couldn't connect to database");

Well i tried changing the dbpass:

$dbpass = "password-i-use";
to
$dbpass = "";

and i didnt get the same error. i got this one:

Error: Couldn't select database.

Well in line 18 i got this (Would help to fix the problem):
mysql_select_db($dbname, $db) or die("Error: Couldn't select database.");

I dont know that i means that i selected wrong database name, and thats why it iant work.

This gotta be bad. I got this in the page that worked:

$dbhost = "localhost";
$dbname = "database";
$dbuser = "";
$dbpass = "";


when this should be the right one, but it didnt work:


$dbhost = "localhost";
$dbname = "database";
$dbuser = "ejviper";
$dbpass = "password";


... Well at least, without user or pwd, works.

I got to thank you all guys who helped me, specialy JayeshJain.
But i still get have the doubt, What do i do to set up user name and password in mySQL?.

check out this link for instructions on securing MySQL ... it should show you how to make it run with a user/password..

http://www.mysql.com/doc/en/Security.html

Hi Guys,

Once you got your mysql,PHP and Webserver sorted you can play with the database add table etc. but doing it from mysql console is very tedious, so personally i recommend (even i use this)
download phpMyAdmin which is intended to handle the adminstration of MySQL over the web

http://www.phpwizard.net/projects/phpMyAdmin/

download from http://www.phpmyadmin.net/index.php?dl=3
and unzip the files in your document root folder you might have to configure but once you have done it you will never have to go to mysql console and you can manipulate mysql from the browser.

Yep! phpMyAdmin is the best.