Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

PHP Using PHP with MySQL Connecting PHP to MySQL Installing MySQL

Sam Katz
Sam Katz
2,986 Points

What will be using MySQL Workbench for?

This will help me decide how to install it. Does Workbench come with XAMPP, MAMP, and DAMP (from Acquia)?

5 Answers

Hey Sam, as far as I know, none of those development environments come with MySQL Workbench, although I've only used XAMPP personally. XAMPP comes with PHPMySQL, if you need a GUI interface for working with your databases, but Workbench is nicer and can be used with any development environment on your machine. I'd also suggest just learning how to interface with MySQL through the command line. It may seem scary at first, but it's actually much faster and easier once you get the hang of it. I suggest running though the new SQL Basics course as well as the Console Foundations course here on Treehouse. And the older course Database Foundations course (confusingly located in the Development Tools section of the library rather than the Database section) shows you how to download and work with MySQL Workbench. :-) In other words, Treehouse has you covered.

Oh and to answer the more basic part of your question, MySQL Workbench serves as a graphical user interface for MySQL., making it easy for you to test and visualize SQL statements before running them.

Sam Katz
Sam Katz
2,986 Points

What I am actually trying to do is prep for learning PHP, and also more importantly, to learn Drupal Views, which is an SQL Query Builder for Drupal as you probably know.

I actually haven't used Drupal before. Most of my learning was initially centered around Wordpress. But the basic PHP and SQL fundamentals are the same. The best thing you can do is just sponge up all the knowledge you can and put things into practice as quickly as possible. And if you run into something you don't know, go ahead and Google it. :-)

Sam Katz
Sam Katz
2,986 Points

Well, Views as I said is an SQL Query Builder for Drupal. There are actually plugins that do the same for Wordpress. You guys have just started training for Drupal, is there someone who would know the answer?

jason chan
jason chan
31,009 Points

I personally just use phpmyadmin. You can run xampp and run workbench. It's just GUI for SQL client. You can also create tables, databases via console.