January 6, 2009

TOTD #60: Configure MySQL 6.0.x-alpha to NetBeans 6.5

Categories: general, netbeans, totd

This Tip Of The Day answers the following comment on my blog:

How to Configure a MySql database to be able to connect Netbeans6.5.?
I've tried using mysql Server 6 many times, but it fails.Please, let me know how to fix that problem.
  • Download MySQL 6.0 from here.
  • Install and start MySQL 6.0 on Mac OSX using the clearly written installation instructions.
    • Basically the download is available in .tar or .dmg format. Using .dmg format is the easiest way, double-click and follow the instructions taking all defaults.
    • MySQL is installed in “/usr/local/mysql-6.0.8-alpha-osx10.5-x86_64″ and the soft link is adjusted so that its available from “/usr/local/mysql”. The directory structure looks like:
      lrwxr-xr-x   1 root  wheel   32 Jan  5 14:00 mysql -> mysql-6.0.8-alpha-osx10.5-x86_64drwxr-xr-x   3 root  wheel  102 Jan  5 14:00 mysql-5.0.45-osx10.4-i686drwxr-xr-x  17 root  wheel  578 Nov  3 21:02 mysql-6.0.8-alpha-osx10.5-x86_64
    • Start MySQL server as: “sudo mysqld_safe” to see the output as:

      ~ >sudo mysqld_safe
      090105 14:20:51 mysqld_safe Logging to ‘/usr/local/mysql/data/dhcp-usca14-133-38.SFBay.Sun.COM.err’.
      090105 14:20:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
  • In NetBeans 6.5, Services tab, right-click on “Databases” and click on “Register MySQL Server…” as shown below:

  • Take the default values, if your MySQL instance is running on the default ports, as shown below:

    and click on “OK”. If your database is already running then NetBeans will automatically connect with the database. If the database is not running then start it as explained above, right-click on the newly added database as shown below:

    and the default databases are then shown as:

More details about configuring MySQL in NetBeans 6.5 are explained in the official documentation.

Please leave suggestions on other TOTD (Tip Of The Day) that you’d like to see. An archive of all the tips is available here.

Technorati: totd netbeans mysql

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • DZone
  • StumbleUpon
  • Technorati
  • Twitter
  • Slashdot
Related posts:
  1. TOTD #38: Creating a MySQL Persistence Unit using NetBeans IDE
  2. TOTD #31: CRUD Application using Grails – Hosted on GlassFish and MySQL
  3. GlassFish and MySQL bundle
  4. TOTD #39: Prototype/Script.aculo.us Autcomplete widget with MySQL, GlassFish, NetBeans
  5. TOTD #107: Connect to Oracle database using NetBeans


  1. how to add plugins on netbeans 6.5
    os windows xp
    example repository:

    Comment by johny — January 6, 2009 @ 6:22 pm

  2. when i type this on the command line

    C:\Program Files\NetBeans 6.5\ruby2\jruby-1.1.4\bin>jruby -S rails hello
    I got a message" The system cannot find the path specified".I just want to ask why i got a result like that instead for create a hello application

    Comment by johny — January 6, 2009 @ 8:59 pm

  3. Am not a Windows person, try going a directory up and say

    bin/jruby -S rails hello

    Comment by Arun Gupta — January 8, 2009 @ 4:09 pm

  4. very nice. thx.

    Comment by sinema izle — March 7, 2009 @ 3:44 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress
168309 visits from Sep 11, 2009