Posts

Showing posts with the label My Server

Connect MySQL with NetBeans

Image
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)...