PHP Using PHP with MySQL Connecting PHP to MySQL Installing MySQL

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

John Roberson
John Roberson
14,999 Points

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.

John Roberson
John Roberson
14,999 Points

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.

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.

John Roberson
John Roberson
14,999 Points

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

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
30,997 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.