Child pages
  • Configuring 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 9 Next »

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

  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 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 privileges. In the MySQL console or your favourite SQL browser execute the following command:
    > CREATE DATABASE `your_database_name`;

  3. Create a user in MySQL

    You may probably want to limit a possible influence on the MySQL server from your expected UGENE users. Then you have to create a distict MySQL user (or a few) for UGENE shared database. In order to do this, execute following commands:
    > CREATE USER `user_nickname` IDENTIFIED BY 'his_password';
    Then you can decide whether this user can modify database content or just view it. In the first case you have to execute the command below:
    > GRANT ALL ON your_database_name.* TO `user_nickname`;
    and for the second one:
    > GRANT SELECT ON your_database_name.* TO `user_nickname`;

  4. The database with "your_database_name" is available from UGENE with the "user_nickname" user name, the "his_password" password.

 

 

  • No labels