X

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

Guest Author


This Tip style="font-weight: bold;">Of style="font-weight: bold;">The style="font-weight: bold;">Day answers the
following href="http://blogs.sun.com/arungupta/entry/screencast_26_develop_run_debug#comment-1230318312000">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 href="http://dev.mysql.com/downloads/mysql/6.0.html">here.
  • Install and start MySQL 6.0 on Mac OSX using the clearly
    written href="http://dev.mysql.com/doc/refman/6.0/en/mac-os-x-installation.html">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:

      style="text-align: left; background-color: rgb(204, 204, 255); width: 100%;"
      cellpadding="2" cellspacing="2">
      lrwxr-xr-x   1 root  wheel   32 Jan  5 14:00 mysql -> mysql-6.0.8-alpha-osx10.5-x86_64
      drwxr-xr-x   3 root  wheel  102 Jan  5 14:00 mysql-5.0.45-osx10.4-i686
      drwxr-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:

      style="text-align: left; background-color: rgb(204, 204, 255); width: 100%;"
      cellpadding="2" cellspacing="2">~ >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:

    alt=""
    src="//cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/f4a5b21d-66fa-4885-92bf-c4e81c06d916/Image/bd4f95c299c80f9b8d27b9a1e4dbb8cf/mysql6_0_nb6_5_register.png">
  • Take the default values, if your MySQL
    instance is running on the default ports, as shown below:

    src="//cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/f4a5b21d-66fa-4885-92bf-c4e81c06d916/Image/3dd012ac3034be31416e537e41e0a7eb/mysql6_0_nb6_5_configure.png">


    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:

    alt=""
    src="//cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/f4a5b21d-66fa-4885-92bf-c4e81c06d916/Image/1635de8b6d07b9476a9223c1d4444fd8/mysql6_0_nb6_5_connect.png">


    and the default databases are then shown as:

    alt=""
    src="//cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/f4a5b21d-66fa-4885-92bf-c4e81c06d916/Image/eb608925ac001b64d6202ec17be08ff4/mysql6_0_nb6_5_default_dbs.png">



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



Please leave suggestions on other TOTD ( style="font-weight: bold;">Tip style="font-weight: bold;">Of style="font-weight: bold;">The style="font-weight: bold;">Day) that
you'd like to see.
An archive of all the tips is available href="http://blogs.sun.com/arungupta/tags/totd">here.




Technorati: totd
netbeans
mysql

Join the discussion

Comments ( 4 )
  • johny Tuesday, January 6, 2009

    how to add plugins on netbeans 6.5

    os windows xp

    example repository:

    svn://rubyforge.org//var/svn/fckeditorp/trunk/fckeditor


  • johny Tuesday, January 6, 2009

    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


  • Arun Gupta Thursday, January 8, 2009

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

    bin/jruby -S rails hello

    ?


  • sinema izle Saturday, March 7, 2009

    very nice. thx.


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.