Unipro UGENE Online User Manual v. 1.14.0
Child pages
  • Connecting to a Shared Database

Versions Compared

Old Version 10

changes.mady.by.user Ivan Protsyuk

Saved on

compared with

New Version Current

changes.mady.by.user Ivan Protsyuk

Saved on

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 have need to have installed 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-adress address of the server (the computer where a MySQL server is running), a user name for the MySQL database and the 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 here.\\in the Configuring Database section.

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

 

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 will appearappears:

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

Here you need to select host, port, database and login and passwordspecify 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 and connection will be created. To initialize the database select it in the list of connections and click on the Connect button. The database will be initialized. , 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 the some connection select the connection and it in the Shared Database Connections dialog and click on the Delete button. To You may also edit the connection select it and click on connection parameters using the Edit button. To connect to the database select it and click on the Connect button. To disconnect to the database click on the corresponding 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.