How to setup MySQL with java using ubuntu in netbeans?

Assumptions

• Virtual Ubuntu box is reachable (IE. Network)
• MySQL setup is running correctly
• Root password is available!

Let’s get started | Download jdbc connector

Go ahead and get the jdbc connector here or just run the following command

Setup database and tables

Log in to MySQL with root

Now let’s create a database called java, and a table called javaTable for this example, will just store the first name, last name and set a primary key to the id.

User authentication

For best practice let’s create a user, that will only be able to interact with the java database and give all privileges.

• Username: javaUser
• Password: oHeyJava

Now that we have a new user let’s log in with those credentials

Now let’s make sure that the database and tables are viewable

Setting up connection on Mac OSX Maverick 10.9 with netbeans

Now that the virtual server is up and running let’s setup netbeans with a new project and call it javaCRUD

Now right click on the project and go to the properties then libraries

Now click on add library select MySQL JDBC Driver click on add to library, click on ok

Now that it’s setup lets write some code

Having network issues?

Wrapping it up

Now at this point, compile and run the class.