Child pages
  • Connecting to a Shared Database

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
To start using the shared database you have to have installed 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: IP-adress of the server (the computer where MySQL server is running), user name for MySQL database and the password. You can also install MySQL server by yourself on any public computer you have an access to (even on your workstation), following the steps described here.\\To connect to the database use the File->Connect to shared database main menu item. The following dialog will appear:

 

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 appear:

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 password. 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. If you want to delete the connection select the connection and click on the Delete button. To edit the connection select it and click on 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.

...