Connect MySQL with NetBeans

A very common problem which recurrs through software development is on how to connect to MySQL Database server using NetBeans IDE. In this post, I intend to present a very clear description on how to do so.

I have used NetBeans 6.1 with MySQL DB Server. But connecting with other versions of the IDE would be similar.

1. Open your IDE and click on the "Services" Tab as shown. If it is not shown, click on Windows->Services to display it.




You can see the Driver for MySQL is already added to NetBeans. Otherwise, right click on "Drivers" and click 'New Driver'. Then show the location of the New Driver.

Right Click on MySQL and Click "Connect Using". Then you should get the following dialog.



2. This dialog requests the relevant configuration details of the Database server.
You can observe a TextBox displaying the "Database URL". This is the connection String used to connect to the database.

There are three main fields which you must supply

a) <Host> : This refers to the IP address of the computer where the Database server is running. If the Database Server is running on your machine, replace with localhost or 127.0.0.1

b) <Port> : Ports are used to differentiate services on the same machine. In most general cases of MySQL installations(ie: If you have not changed the default values), the port where MySQL runs is 3306. You can safely replace by 3306

c) <DB> : DB refers to the Database which you need to connect to. Since a Database Server can host multiple Databases at once, you need to specify which Database you need to connect with. In my case I have a Database named "Drupal"

Then fill in the username for the database and the password. By default, the root user has password root or none(blank).

After filling the configurations, it should look something similar as the following.




After entering the data, click on the "Advanced" tab and click on the "Get Schemas" button. If successful, you should get a message saying "Connection Established" as shown below.




3. After successful configuration, you should observe the following under services tab.





NOTE: You may not be able to view anything under tables is you do not have any tables. Also observe the icon for displaying the connection is slightly different now, showing that a connection has been made.

4. Once you have done that, you may need to try and execute some SQL commands. To do so, right click on the connection icon and select "Execute Command" as follows.





You would be taken to a new window as shown below.(The results would be visible only after execution of the command)





5. Now, type 'select * from ' and click on the Execute button which is circled in red.
If you have data in your table, you should be able to view them in your bottom left corner of the screen.

Have fun guys

Comments

Amit Saha said…
SQL editor and some other stuffs related to MySQL have been vastly improved in NetBeans IDE 6.5+. You might want to try that.
May 14, 2009 at 1:44 AM
ruchira said…
Hi Amit,
Yes, I have used NetBeans 6.5 and its improved features for development, but since a considerable amount of people still use earlier versions, I believe this would benefit for them.
Anyway, thanks for mentioning.
May 14, 2009 at 3:30 AM
Anonymous said…
nice templates.i use this templates.
more templates
http://www.itsolusenz.com
May 16, 2009 at 12:02 AM
Post a Comment

Popular posts from this blog

Encrypt and Decrypt Images Using Java

Hi, Most of you would find it useful to Encrypt a special picture of yours such that only you can view it. By using JCE(Java Cryptography Extension) classes, this becomes very simple. As I have already done before using Java to encrypt a String is very simple. If you are new to this, please read the article which I had already posted named "Java Encryption and Decryption" at "http://ruchiram4.blogspot.com/2009/04/java-encryption-and-decryption.html" Also, you need to have a basic understanding of Java IO. If you are new, it is better to read the Sun Java tutorial on IO. Before we move on, lets recall the basic steps in Encrypting plaintext. 1. Creating an instance of "Cipher" object and setting the mode of Encryption (Eg: AES, DES) 2. Generating a key by using a KeyGenerator object. 3. Setting the mode of Cipher operation on the Cipher object. As we intent to Encrypt, we simply set it by setting a property of Cipher object by calling its "init"
Read more

Build your own Network sniffer

Image
Recently, I ve been developing a tool to monitor the Network Traffic as an assignment. Here, I wish to share my experience with all of you who are interested in building your own Sniffer. Prerequisites : Java Programming capability, Knowledge on OOP(Object Oriented Programming) basics My Environment: I used the libraries specified for Java which is widely available. I ran my application on Windows XP only. But the libraries can be easily integrated with Linux based systems. I used NetBeans 6.1 version for development activities. But any other java IDE would do In setting up the environment, first you need to download Jpcap jar found at http://sourceforge.net/projects/jpcap Once you download this, you have to add this to your NetBeans project. It can be done as follows. After adding the Jar file to the project, you need to download the WinPCap driver. It can be easily downloaded from http://www.winpcap.org/ It is required to get low level networking access regarding packets. As for
Read more

ASP Response.Write newline

Hi, all of you who have used ASP may have encountered situations where you require to write a text output to the screen. It can be easily done by using Response.Write("Hello world"); However, if you wish to append some more text to a newline, it would not work in the following ways. Response.Write("Hello world \n"); Response.Write("Good day."); The output of the above lines would be Hello world Good day. and NOT Hello world Good day. In order to overcome this, you can very simple place an html break tag inside the code. Response.Write("Hello world"); Response.Write("<br/>"); Response.Write("Good day."); The output would be the following. Hello world Good day. Cheers !!!
Read more