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 12 Next »

To make use of a shared database follow the 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 5.5 and higher. Here you can also find instructions on how to 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 administrative 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 favorite SQL browser execute the following command:
    > CREATE DATABASE `your_database_name`;

  3. Create database users

    You may probably want to limit possible influence on the shared database by the UGENE users who will use it. In this case create a distinct MySQL user for each UGENE user (or a group of users). In order to do this, execute the following commands:
    > CREATE USER `user_nickname` IDENTIFIED BY 'user_password';
    Decide whether the created user is allowed to modify the database content or only to view it. In the first case execute the command below:
    > GRANT ALL ON your_database_name.* TO `user_nickname`;
    and in the second case execute:
    > GRANT SELECT ON your_database_name.* TO `user_nickname`;

  4. 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 "user_password" password.

 

 

  • No labels