GUI? How to inspect tables, modify structures in online database?

[sneakyimp]

hey folks:

so i've just been assigned some PHP scripting work on a site that queries and writes to a MySQL database. I'm going to have to add some fields and i have almost no idea what the internal data structures look like. Would the MySQL server have some kind of control panel that would provide visual/GUI interface for doing this?

Can anyone recommend a package that will help me formulate & test complex queries, modify tables and data, and generally maintain the database in a user-friendly environment?

THANKS!

[Decker]

You can do all that here - with a decent CPL - and probably all the functions you need.

[sneakyimp]

do all that where? and what's a CPL?

maybe i wasn't clear...i am a PHP developer (a very new one at that) and I have to alter a database that lives on a server in Little Rock AR (i live in Los Angeles). as much as i'd love to be a valuehost customer, this will not happen?

i need to understand how one can inspect and alter the database over the internet (ideally with a GUI interface). does MySQL have a control panel or something which does this? do i need to buy some third-party software like they have at
www.dbqwikedit.com?

please advise.

[dom]

sneakyimp you need phpmyadmin http://www.phpmyadmin.net/ it very easy to install.

Or a very good perl alternative http://dajoba.com/projects/mysqltool/

Or if you have some cash invest in phplens and save lots of time http://phplens.com/