Team:UC Berkeley Tools/Project/Tutorial/Database

From 2008.igem.org

(Difference between revisions)
(New page: center {{Template:ClothoMenu}} {{Template:ClothoTutorialVerticalMenu}})
Line 4: Line 4:
{{Template:ClothoTutorialVerticalMenu}}
{{Template:ClothoTutorialVerticalMenu}}
 +
 +
 +
      <p><strong>7)  Connecting to a Database</strong></p>
 +
[[Image:Tut7.PNG|right]]
 +
    <p>Some of  Clotho's most interesting features can only be utilized once we've connected to  a database.  Let's try setting up a  mySQL connection: on the Main Toolbar select &quot;PoBoL based mySQL&quot; from  the I/O drop down menu.  This should  bring up the mySQL/PoBoL Configuration window.  The first two boxes are username and password, but don't put anything in  them just yet.  First, select the  &quot;Create New  Connection&quot; tab,  and enter the following information:</p>
 +
    <p>Name:<br />
 +
      Host:<br />
 +
      Port:<br />
 +
      Database:</p>
 +
    <p>After  you're done, click &quot;Create&quot; and go to the &quot;Existing  Connections&quot; tab.  Select the  connection you just made from the &quot;Connection Available&quot; drop down  menu.  In the appropriate boxes, put in  the username **USERNAME** and password **PASSWORD**.  Then click &quot;Set as    Next, we'll setup the PoBoL binding file: click the &quot;View PoBoL  Binding&quot; button, and it should bring up the PoBoL Binding window.</p>
 +
<p>&nbsp;</p>

Revision as of 08:39, 20 October 2008

Clotho Title small.png


 


7) Connecting to a Database

Tut7.PNG

Some of Clotho's most interesting features can only be utilized once we've connected to a database. Let's try setting up a mySQL connection: on the Main Toolbar select "PoBoL based mySQL" from the I/O drop down menu. This should bring up the mySQL/PoBoL Configuration window. The first two boxes are username and password, but don't put anything in them just yet. First, select the "Create New Connection" tab, and enter the following information:

Name:
Host:
Port:
Database:

After you're done, click "Create" and go to the "Existing Connections" tab. Select the connection you just made from the "Connection Available" drop down menu. In the appropriate boxes, put in the username **USERNAME** and password **PASSWORD**. Then click "Set as Next, we'll setup the PoBoL binding file: click the "View PoBoL Binding" button, and it should bring up the PoBoL Binding window.