Child pages
  • Connecting to a Shared Database

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3
To start using the shared database you need to have a running public MySQL database server. Usually the system administrator of your department does it. You should ask him or her to give you the access to a MySQL database. Particularly, you need a few parameters to connect to the database: the IP-address of the server (the computer where a MySQL server is running), a user name for the MySQL database and a password. You can also install a MySQL server by yourself on any public computer you have an access to (even on your workstation), following the steps described in the Configuring Database section.

To connect to the database use the File->Connect to shared database main menu item. The following dialog appears:

 

HTML
<center>
  <br>
  <img src="/wiki/download/attachments/8093779/Connections Manager.png"/>
  <br> 
</center>

To add new connection click on the Add button. The following dialog appears:

HTML
<center>
  <br>
  <img src="/wiki/download/attachments/8093779/Connections Manager_1.png"/>
  <br> 
</center>

Here you need to specify Host (IP-address of the server), Port (number of the port used by the MySQL server) and Database (name of the database). You may also fill Login and Password fields. Otherwise, you are asked to input them every time you are establishing this connection until you check the Remember me box. Click on the OK button, then the connection is created and the appropriate item appears in the previous Shared Database Connections dialog.

If you want to use already existing connection choose the appropriate item in the Shared Database Connections dialog and press the Connect button. This can also be done by double clicking the item. If the specified database is empty, UGENE has to initialize it. This routine is done only once. In this case you get an appropriate message box, asking whether to initialize the database or not. If you choose Yes the database is populated with UGENE data structures, if No it remains empty and UGENE does not connect to it.

If you want to delete some connection select it in the Shared Database Connections dialog and click on the Delete button. You may also edit connection parameters using the Edit button.

An established connection can be terminated by pressing the Delete button. The same effect is produced by removing the database document item from Project View.