Page 1 of 1

Best way to view/edit MySQL databases on a given server?

Posted: Tue May 20, 2008 2:52 am
by mirra1515
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!

Re: Best way to view/edit MySQL databases on a given server?

Posted: Tue May 20, 2008 5:01 am
by VladSun
Web based (i.e. PHP): phpMyAdmin
Desktop: MySQLfront

Console (i.e. shell, command prompt):
Linux:

Code: Select all

mysql -uUSER -pPASSWORD
Windows

Code: Select all

mysql.exe -uUSER -pPASSWORD
opens a MySQL prompt:

Code: Select all

mysql> show databases;
mysql> use mydatabase;
mysql> show tables;
mysql> describe mytable;
mysql> select * from mytable;

Re: Best way to view/edit MySQL databases on a given server?

Posted: Tue May 20, 2008 6:04 pm
by flying_circus
Vlad, why do you recommend MySQL Front over the mysql gui-tools available from mysql?

Re: Best way to view/edit MySQL databases on a given server?

Posted: Tue May 20, 2008 6:24 pm
by VladSun
:) I don't know - the first one that came in my mind :)