Posts: 27
Name: Mike Robinson
Location: London, England
|
Quote:
|
My question is I want to learn MySQL so I figured installing it along with PHP and Apache would be good for learning but I see on my hosting account I have 25 MySQL databases to use... What are the downloads for to turn my computer into a server and keep on while people access data or do I build the database on my pc locally and then upload to the server.
|
Server route
If you just want to try out MySQL then just use the MySQL on your server. Either get a book or follow examples off the web. SQL isn't difficult to learn.
At a later date you can try writing some web pages in PHP that access your database - it's not difficult if you follow examples on the web and, if it works for you, then it will also work for anyone else who wants to accesses your web pages.
The only reason not to use your servers MySQL is if you want to use stored procedures and the MySQL you are currently given is before version 5. Another slight difficulty is having to access MySQL via a terminal style connection which might be a bit basic for you - you could try out SQLyog or phpMyAdmin which allows you to build scripts on your PC and run them on remote servers.
PC route
If you want to turn your PC into a server (with the features you're after) then you'll need to install Apache, MySQL and PHP. You'll also have to have your PC permanently connected to the web and have these services permanently running - otherwise people won't be able to access your application/web pages on your PC.
You'll also need to assign a name for your PC so people can get to it (ie www.myGreatApps.com) - you can do this cheaply through Go Daddy.
My advice
I'd just use the services supplied to you through your hosting account as you're already paying for it and it's the path of least resistance.
Other advantages are that they'll back up your database etc and provide you with help if needed. If you turn your home PC into a server then you're on your own.
Mike |
