To make use of a shared database you have to follow the next steps below:
- 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. - 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`; - Create a user in MySQLdatabase users
You may probably want to limit a possible influence on the MySQL server from your future 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 the 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 ON your_database_name.* TO `user_nickname`;
and for in the second onecase execute:
> GRANT SELECT ON your_database_name.* TO `user_nickname`; - The database with "your_database_name" is now available from a UGENE instance (version 1.14 or higher) with the "user_nickname" user name , and the "hisuser_password" password.