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

Development Tools Database Foundations Installing MySQL Server and MySQL Workbench Installing MySQL Server and Workbench on OS X

Robert Mews
Robert Mews
11,540 Points
Posted by Robert Mews
Robert Mews
11,540 Points

Foundations of MySQL?

Could someone point me to a course that talks about the foundations of MySQL? I'm taking this video as part of the PHP course and MySQL is on a live server. This video doesn't help with understanding the foundations, which I was anticipating as part of the PHP course.

I'm completely lost as I don't know how to structure or connect to MySQL databases. I'm assuming phpMyAdmin is the same as Workbench, but how do I setup config files, write scripts, etc would be nice to learn before learning how to writing commands to a database.

1 Answer

Shane Meikle
Shane Meikle
13,188 Points
Shane Meikle
Shane Meikle
13,188 Points

Workbench and phpMyAdmin are similar in that they are both GUI's for manipulating the MySQL database(s).

http://teamtreehouse.com/library/database-foundations

Is a good resource, and will get you on the right track. If that isn't what you are looking for, maybe provide an example of exactly what you are looking to learn and we can go from there :)

Robert Mews
Robert Mews
11,540 Points
Robert Mews
Robert Mews
11,540 Points

Thanks, Shane. I'm quite new to database structures and how to do commands using these UI's. I'm quite unfamiliar with the UI's components between phpMyAdmin and Workbench. I'm afraid to hit a button or don't really have the understanding of what all the capabilities of the UI entails. Maybe I just need to google more and get the overview before diving into this course.

Shane Meikle
Shane Meikle
13,188 Points
Shane Meikle
Shane Meikle
13,188 Points

I would recommend using a local server (if using Windows, Wampserver would be a good package) to do some testing and playing around with the various things.

I am not sure what you are needing as a precursor to that course, as it does discuss all the beginner level content and builds on it. I suggest diving into a couple of the first videos in the course and see how you do and then go from there (either continue on the course, or do some more Googling).