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
allensimbul
3,065 PointsDatabase 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
19,323 PointsNahh! 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
19,323 PointsYeah! 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
19,323 PointsHiya 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. (:
allensimbul
3,065 PointsSo 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?
allensimbul
3,065 PointsSo 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?
allensimbul
3,065 PointsI 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
19,323 PointsYeah 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
19,323 Pointsyou're the admin user!
allensimbul
3,065 PointsBut I do understand more about databases now. Thank you.