First MySQL enabled website

Can I do it all in phpMyAdmin

[bubster119]

I want to create a simple MySQL enabled PHP website. The database will host a list of projects with I hope to sort by date and type.

My question is, my hosting allows me to create and manage MySQL databases through my control panel and phpMyAdmin so is it still necessary for me to install MySQL locally on my computer for such a simple database?

Any advice would be greatly appreciated since this is my first MySQL project.

[rsndll]

I have a mySQL-enabled web site and I don't have mySQL on my own PC.

The drawback is that you have to do all testing etc. online.

[bubster119]

I'm more than happy to test online, it's not much of an inconvenience considering the speed of broadband etc.

It would be more hassle to install it on my mac and have to configure the software firewall in OSX.

[Discovery]

Its good, If you can do testing stuffs in local machine for this you can install, using
1) LAMP package for linux
2)WAMP package for Windows

Or you can Install only Mysql.
[caucuscare.com...]
[washington.edu...]

But its not necessary mysql on local machine, What you can, you can created two database using phpmyadmin with your hosting company.
One for testing and other for your production.

[souFrag]

I recommend you XAMPP:
[apachefriends.org...] (MacOS version)

It doesn't even require an "installation"... just unzip it and click on "start" when you want to run your local server.

[Discovery]

thats, the great souFrag,

I have never tried this, because i don't have MacOS, this will really helpful for MacOS user.

[edited by: Discovery at 4:53 am (utc) on April 14, 2007]

[souFrag]

XAMPP is available for Win, Linux, Solaris, Mac:
[apachefriends.org...]

It's really useful when you need a quick and simple test environment without having to "install" anything and mess up your OS :-)

[steve]

I have XAMPP running on a USB stick, so I can move it between (Windows) computers.

It includes phpmyadmin which I've been using to create and populate databases and test SQL queries.

Its easy to install, just unzip and run the setup file, and away you go.

[Discovery]

ooh, thanks again, i will sure try.

[souFrag]

Its easy to install, just unzip and run the setup file, and away you go.

You don't even need to run a setup file if you download the ZIP version instead of the Installer :-)

With the ZIP version you've just got to unzip it and run xampp-control.exe.

[steve]

With the ZIP version you've just got to unzip it and run xampp-control.exe

I would avoid xampp-control it has a memory leak problem, use 'xampp start' and 'xampp stop' instead.