Which version of MySQL should I download to use with Eclipse for Java programming on my Mac OS X Mavericks?

Question

Level 1

8 points

Which version of MySQL should I download to use with Eclipse for Java programming on my Mac OS X Mavericks?

I have recently enrolled in a course to learn Java. I have installed Eclipse on my Macbook Pro (OS X 10.9 Mavericks) and it works fine. Now, the thing is, we have got to the part where I need to start using databases with my Java programs using JDBC-ODBC.

I understand that MS SQL Server is not available on the Mac platform. I assume the next best alternative is MySQL.

When I go to the MySQL webpage to download, I see quite many different types - http://dev.mysql.com/downloads/

My question is, which one should I download that will be suitable to my needs? I am totally in the dark about this as I am new to DBMS and the Mac OS as well. Any suggestions will be highly helpful.

MacBook Pro, OS X Mavericks (10.9.3)

Posted on May 28, 2014 4:38 AM

Reply

Answer 1

supriya84 Author

Level 1

8 points

May 29, 2014 5:27 AM in response to supriya84

Ok so I installed the MySQL Community Server and all seems to be well so far. However, I dont see an interface/application to write queries to create DBs and check it they are ok before actually accessing them through my Java applications. So do I download WorkBench now? The download page says:

MySQL Workbench Prerequisites: [+]

To be able to install and run MySQL Workbench 5.2 your System needs to have libraries listed below installed. The listed items are provided as links to the corresponding download pages where you can fetch the necessary files.

Does this apply for a Mac installation as well?

Also, do I need to download any connectors from the MySQL website to be able to connect my java applications to the server?

Reply

Answer 2

Barney-15E

Level 10

122,756 points

May 28, 2014 4:44 AM in response to supriya84

I'm not sure what MySQL Server is as MySQL is a SQL server.

Use the Enterprise edition.

Also download the Workbench. It makes managing the instances and access permissions easy. However, I hope the class will just give you the commands to set up the database to use with your assignments--they don't have time to teach you to be a DBA, also.

I enjoyed using Eclipse. It had a lot of nice features. There is a tutorial somewhere on their website which shows you how to take advantage of the features of the IDE. It took a few hours to go through all the lessons, but I thought it was worth the time.

Reply

Answer 3

supriya84 Author

Level 1

8 points

May 28, 2014 4:48 AM in response to Barney-15E

Yes, they will give us the code to set up the DBs to use for our assignments.

Just a thought... isnt the Enterprise edition a paid version ? I clicked through the download steps and read somewhere that they offer a 30 day trial and then you have to obtain a license from Oracle.

Also, I suppose I will be needing some form of a query analyser as well as a client and server side of the DB. Will all this be included in the Enterprise edition?

Reply

Answer 4

Barney-15E

Level 10

122,756 points

May 28, 2014 4:54 AM in response to supriya84

Sorry, you're right. It is the Community Server. I glossed over that one and thought the Enterprise version was what was needed.

You don't need a "query analyser" at all, for any SQL server--it might be a handy tool, but it is not required especially for your needs.

MySQL is the Server and you can access it as "client" from the command line, or use a GUI tool to "talk" to it.

The MySQLWorkbench will be sufficient. It has a SQL editor and viewer to examine the schema.

However, your java app will be the client in this case.

Reply

Answer 5

supriya84 Author

Level 1

8 points

May 28, 2014 5:21 AM in response to Barney-15E

Right ! Thank u. I will install it tonight and post again if I run into any problems.

By the way, the Workbench will provide an interface to manually create databases and run queries to retrieve data, right?

Reply

Answer 6

Barney-15E

Level 10

122,756 points

May 29, 2014 3:31 PM in response to supriya84

You've got the wrong one. You need the one for OS X. http://dev.mysql.com/downloads/workbench/

And, you don't need a GUI. You can do it all in the Terminal.

Just type mysql and it will give you a prompt and you can create tables, queries, etc.

Nothing special needed. http://www.w3schools.com/sql/default.asp

Reply

Answer 7

supriya84 Author

Level 1

8 points

May 29, 2014 9:20 PM in response to Barney-15E

Thats the one I have downloaded. If u see, there is a heading "Pre-requisites...". If you click on the + sign next to it, it expands to show what I said earlier.

Yes, I know I dont need a GUI per se.. but I would like one, instead of using Terminal. So I guess I will install Workbench and have to figure out how to configure it to MySQL Server.

Reply

Answer 8

joepke

Level 1

145 points

May 29, 2014 11:13 PM in response to supriya84

Supriya84, those prerequisites are for Microsoft Windows.

To install MySQL Workbench on OS X Mavericks follow the instructions mentioned here: http://dev.mysql.com/doc/workbench/en/wb-installing-mac.html

Another GUI tool I can recommend is Sequel Pro: http://www.sequelpro.com

Reply

Answer 9

supriya84 Author

Level 1

8 points

May 28, 2014 7:03 AM in response to supriya84

Also, my Macbook Pro runs OS X 10.9 Mavericks. The link for downloading MySQL only provides till OS X 10.7. Any idea if it will work on my OS as well?

Reply