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!
Best way to view/edit MySQL databases on a given server?
Moderator: General Moderators
Re: Best way to view/edit MySQL databases on a given server?
Web based (i.e. PHP): phpMyAdmin
Desktop: MySQLfront
Console (i.e. shell, command prompt):
Linux:
Windows
opens a MySQL prompt:
Desktop: MySQLfront
Console (i.e. shell, command prompt):
Linux:
Code: Select all
mysql -uUSER -pPASSWORDCode: Select all
mysql.exe -uUSER -pPASSWORDCode: Select all
mysql> show databases;
mysql> use mydatabase;
mysql> show tables;
mysql> describe mytable;
mysql> select * from mytable;There are 10 types of people in this world, those who understand binary and those who don't
- flying_circus
- Forum Regular
- Posts: 732
- Joined: Wed Mar 05, 2008 10:23 pm
- Location: Sunriver, OR
Re: Best way to view/edit MySQL databases on a given server?
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?
There are 10 types of people in this world, those who understand binary and those who don't