Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 ..)

share|improve this question

4 Answers 4

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.

share|improve this answer

You have many choice:

  1. Phpmyadmin (installed by xampp)
  2. MySQL Query Browser
  3. SQLYog (Not Free)
  4. MySQL WorkBench
share|improve this answer
2  
MYSQL Query Browser has reached EOL (End of Life) so now you use the tool within MYSQL workbench, which is pretty darn good. dev.mysql.com/downloads/workbench –  Linker3000 Dec 6 '10 at 19:40

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

share|improve this answer

Use Base application of OpenOffice with its MySQL connector plugin.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.