How to setup MYSQL and PHP on my 2003 web server

I am new to this and have recently decided to get a windows 2003 web server on a rental deal from my ISP.

I'm trying to setup the server to allow me to get used to hosting both simple and database driven websites.

My server has been running fine for over 4 months with the simple stuff I have thrown at it and it's now time to get my head around websites with databases.

I have got hold of PHP and MySql and I'm now stuck. I want to be able to host PHP pages and also setup databases for a number of different websites, each website having it's own individual user that can only use their allocated database.

I have decided to stop trying to play & learn my way through this and instead want to get the advice I need to make sure I setup my server correctly.

Where do I start?
What do I need? It has to be free.


thanks
John
oktohostAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CiaranDolanCommented:
These are two of the simplest setups you will ever do on Windows.

First you need MySQL for Windows and then you need PHP for windows. Both of them should be the binaries.

For MySQL follow - http://dev.mysql.com/doc/mysql/en/windows-installation.html
For PHP follow - http://www.webmasterstop.com/123.html

You can now install something like PHPMYADMIN as in this article - http://denbourdon.free.fr/development/php4iis5/php4iis5_en.htm

Alternatively you can do all the MySQL admin using the MySQL Administrator (http://dev.mysql.com/downloads/administrator/1.0.html) which is my preference.

Under MySQL be aware of the different users and their access. When you create a user you will specify where they can login from - generally for a server set up like yours you would specify <user>@localhost. Then you would 'grant' that user access to each of the databases they need access to.

How is your MySQL and PHP knowledge? The setup is easy - the development of the end applications is not.

It's all free although investing in a good book on MySQL/PHP applications would probably be a good idea.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
oktohostAuthor Commented:
The comments were only re-itterating what I had already mentioned as the above links go to the sites I already downloaded the software from and had read.

thanks for the 1 response, but yes please close this now.

John
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.