Editing an SQL Database

Question

I'm new to php, so I installed xampp for windows.

Is there a windows software for easy MySQL administration? (creating/displaying/editing tables + data, creating relations ..) i've managed to open MySQL databases with ms access but it's a bit tricky.

my 2nd question: where exactly is the MySQL data stored? is it stored in a physical file which can be deleted/copied like ms access files? when working with colleagues, I'm finding it a bird hard synchronizing data if someone changes something (the database needs to be exported - imported ..)

Answer 1

first question, phpmyadmin is pretty much the defacto for that setup. second, with a larger implementation of SQL, its not that simple. The phpmyadmin interface gives you options for backup and reinstatement of your database through the gui, that is how you should do it.

Answer 2

You have many choice:

1. Phpmyadmin (installed by xampp)
2. MySQL Query Browser
3. SQLYog (Not Free)
4. MySQL WorkBench

Answer 3

One of the best and most oft used Database Management tools is PHPMyAdmin.

PHPMyAdmin has quite a user friendly interface and thus is most popular amongst beginners. PHPMyAdmin provides the users with a feature rich interface that does the work well and is easy to understand and work with. Here is a great resource to learn the interface for PHPMyAdmin.

Yes. The data for MySQL is stored like any other data on your computer. You can find all the MySQL tables and databases you make in:

C:/xampp/mysql/data

Happy Coding! :D

Answer 4

Use Base application of OpenOffice with its MySQL connector plugin.