Page History

To make use of a shared database you have to follow the next steps below:

1. Deploy a MySQL database server
   
   We recommend you to download MySQL binaries from the official site. Note that UGENE supports MySQL versions from 5.5 and higher. Here you can also find the instructions about on how to launch install and launch a MySQL server instance for each platform.
   
   
2. Create an empty database
   
   Log in to the MySQL server as a user with privileges of creating database, users and granting privilegesadministrative privileges (you must be able to create databases and users, and to grant privileges to the created users). In the MySQL console or in your favourite favorite SQL browser execute the following command:
   > CREATE DATABASE `your_database_name`;
   
   
3. Create a user in MySQLdatabase users
   
   You may probably want to limit a possible influence on the MySQL server from your expected the shared database by the UGENE users . Then you have to who will use it. In this case create a distict distinct MySQL user for each UGENE user (or a few) for UGENE shared databasegroup of users). In order to do this, execute the following commands:
   > CREATE USER `user_nickname` IDENTIFIED BY 'hisuser_password';
   Then you can decide whether this user can modify Decide whether the created user is allowed to modify the database content or just only to view it. In the first case you have to execute the command below:
   > GRANT ALL CREATE, SELECT, INSERT, INDEX, UPDATE, DELETE, CREATE ROUTINE, EXECUTE, DROP ON your_database_name.* TO `user_nickname`_nickname`@'%' IDENTIFIED BY 'user_password';
   and for in the second onecase execute:
   > GRANT SELECT ON your_database_name.* TO `user_nickname`;
   nickname`@'%' IDENTIFIED BY 'user_password';
   
   
4. Use the database from a UGENE instance
   
   The database with "your_database_name" is now available from a UGENE instance (version 1.14 or higher). It's time to try it out and fill it with some initial data. To do it, open UGENE and connect to the database. As we need to add the data to the database, use "user_nickname" and "user name, the "his_password" passwordof a user with privileges to modify the database. As soon as connection is established, add the required data to the database.
   
   From now on the data will be available for all users from this and other UGENE instances who connected to the same database.