Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases

Database Questions

Hello I have very cursory knowledge of how mysql works and how databases works so I would greatly appreciate if you can help me with the following questions:

What's the difference between the Mysql community version and the paid mysql version?

What does installing mysql community version on Macbook do?

When I install Mysql community version on my Macbook does that allow my machine to connect to their databses/servers?

Is the mysql database that I made stored on mac or on there servers? If on my mac, then why is this? From my understanding I would have thought they will be saved on there servers?

I plan on using Mysql for a programming project, when I save my data from that project to the mysql server/database is that stored online on their servers or on my ssd?

8 Answers

Ari Misha
Ari Misha
19,286 Points

Nahh! It'd allow you to connect with the DB. When you use mysql console, it gets connected to your db and with the help of console, you can perform queries on it, right? Like "SELECT * FROM table_name" is a sql query. Now let just say you want to perform this query on an existing database containing table "table_name". How would you do it? Thats where the mysql console and mysql server comes in. MySQL server connects your console to your database stored on your pc. And with the help of your console , you can query the database ad interact with it.

Ari Misha
Ari Misha
19,286 Points

Yeah! Thats correct! Your DB(database) needs a server to connect to it, i mean if it wont how else would you interact with DB, right? Besides in real life, nobody stores DB on servers, they get deployed with your applications and it grows with the scale of your application. MySQL server is exactly like "localhost" when your application is in development mode. (:

Ari Misha
Ari Misha
19,286 Points

Hiya Allen! MySQL community version is light weight than Paid MySQL version. If you're a part of team and working on a project and you chose MySQL database as your primary db , thats when you'd wanna use paid version coz of the scalability and the size of the project, right? But if you're working with individual and small projects, Community version is great for you. And it serves all your needs. (:

And as far as connecting to MySQL server goes , it just means you're connected to your database and you are a valid user to access the database on your local machine. All your database gets stored on your machine , not servers. (:

So If I choose to download the MySql Community Version for my Macbook, any databases i make are stored on my Macbook ssd rather than a mysql server online?

Am I understanding that correctly?

So in a way when I install mysql com ver it turns my macbook into a server which would allow the user account on my macbook to connect to the server(which is my macbook) ?

Is that correct?

I see, is this console the MySql Workbench? Is this database private? So say I do install the community version onto my macbook would I be the only one that can connect to this database on my ssd?

Ari Misha
Ari Misha
19,286 Points

Yeah its only visible to you! And it also lets ya add a password and username , so that nobody else could access your DB files. I use windows so i dunno much about Mac but im pretty sure anyone access with super user or admin can set the password and user to connect to DB.

Ari Misha
Ari Misha
19,286 Points

you're the admin user!

But I do understand more about databases now. Thank you.