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

Walter Bueso
Walter Bueso
10,654 Points

Beyond frustrated with "Database foundations" course! Why are we not using XAMPP/MAMPP?

Not a question, more of a feedback

XAMMP was shut off during the installation process

I have wasted so much time downloading and removing content from mysql.com because I cannot get the software to work.

Problem: My first attempt downloading MySQL was from the link Andrew Chalkley provided us in the video "Installing MySQL server and WorkBench on windows". After the download was complete, WorkBench did not boot up automatically and I couldn't find any files or options on my computer that can open up WorkBench. So I removed the program and tried again from the actual website, but that also did not work. Now I'm not sure if this had a direct impact on the installation process but the Mysql installer was requiring me to manually download Excel. I'm not going to download excel because Microsoft office is not free nor cheap. So I ignored this step and continued on with the installation process(Alert recieved but based the alert, it didn't seem like ignoring this step would doom the enitre installation process) and the software just did not work. I made another attempt but this time with the latest version but WorkBench was completely different from Adrew's videos which made it difficult to follow along and I was unable to upload the moives_db.sql file.

Complaint: Our first project in the PHP track had us downloading XAMPP/MAMPP to perform php code and this was a very smooth process. I noticed that MySQL was also included in the package so why are we not using the SQL in xammp on the database foundations course? It'd would be a lot easier to strengthen our knowledge in a familiar software and we would avoid cramming up our computer from the additional 3rd party applications(Excel and Visual Studio) the mysql.com installer is requiring us to install. I quickly found myself spending more time trying to get the program working than learning Database Foundations and this has been extremely frustrating for me. Please help!

It may not be fair to speak so negatively on this course when I've barely made it through the second stage, but this has been the second time I've encountered an unpleasant learning experience (Jquery and Database Foundations) with Andrew Chalkley.

2 Answers

I've never heard of a MySQL product requiring Excel or Visual Studio, it makes no sense. I think you installed a different product that for some reason asked your for Excel and/or Visual Studio. I have been using MySQL for 15+ years and never had to install Excel/Visual Studio. Moreover, I have been using Workbench for many years and it never asked for any Microsoft software for it to work. Clearly you are confused with what you need for the class and I hope someone here can help you.

Lastly, while XAMPP/MAMPP may install the MySQL server it may not install Workbench, which is a tool that many database administrators use. I definitely think it is beneficial to learn Workbench even if down the road you end up using other tools like SQLYog .

jason chan
jason chan
31,009 Points

you can use xampp just have the sql server on. then install workbench. turn on xampp mysql and workbench on.