Child pages
  • Connecting to a Shared Database
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

To start using the shared database you have to have 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: 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 appears:

 



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



Here you have 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 and the connection is created and the appropriate item appears in the previous Shared Database Connections dialog.

Later on you can use this connection to access the database. 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.

 

  • No labels