PHPAdmin

[laychoo135]

May I know what's the purpose of installing PHPAdmin? Do I install on my pc(windows) or on my Apache server?

How to do the installation.

Kindly help!

[raf]

I suppose you refer to phpMyAdmin ?

It's just a web-frontend that generates the sql-statements for you + has a window where you can type in the statement + a sort of script-import function so that you can prepare the sql-statement in wordpath or so (or copy it from somewhere into a textfile) and then import and execute it.
But it can't do anything you couldn't do yourself by typing in the command at the commandline, or by writing a PHP or ASP file or so with the sql-querys in it as embedded sql.

It's just one of the frontends, that make it easier to create/modify tabels, administer your db, create users etc etc. But there are a lot of other products. Just google for 'MySQL frontend GUI' or so, and you'll see some alternatives.

Or take a look at other alternatives here
http://www.mysql.com/portal/software/web-tools/index.html

Where to install it? I'd recommend installing it on the machine where your webserver (Apache) runs on. But there are a lot of client-db-frontends, that you can install on your PC (which is what i like to do, so i can use the same frontend for my development database on my PC, as for the production db at the server)
Note : if your site is hosted, then the host will probably have a MySQL frontend installed on the server, and they'll probably don't allow you to use a client-frontend.