Best way to view/edit MySQL databases on a given server?
Posted: Tue May 20, 2008 2:52 am
I am working with the localhost server on my computer for the moment and I would like to be able to simply manage the database I create and edit with php scripts on my various test sites. Preferably, I would like to just install some sort of software that can view what tables are within the localhost databases and what columns are within those tables.
I have worked with MSSQL in the past, and they have a simple database manager that serves this purpose, but I haven't seen such a thing with MySQL. I installed MySQL with XAMPP, so that could have something to do with it. What's the best software set (or php script) that would allow me to manage their databases?
I am always creating and editing tables and it's hard to tell if new columns are being created and so forth...so having the capability to simply view the columns for a given table would be spectacular. Thanks for any suggestions!
I have worked with MSSQL in the past, and they have a simple database manager that serves this purpose, but I haven't seen such a thing with MySQL. I installed MySQL with XAMPP, so that could have something to do with it. What's the best software set (or php script) that would allow me to manage their databases?
I am always creating and editing tables and it's hard to tell if new columns are being created and so forth...so having the capability to simply view the columns for a given table would be spectacular. Thanks for any suggestions!