Date: Fri, 29 Mar 2024 14:51:23 +0700 (NOVT)
Message-ID: <82371349.88896.1711698683201@ugene.net>
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="----=_Part_88895_1658696719.1711698683201"
------=_Part_88895_1658696719.1711698683201
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Location: file:///C:/exported.html
Configuring Database
Configuring Database
To make use of a shared database follow the steps below:
- Deploy a MySQL database server
We recommend you to down=
load MySQL binaries from the official site. Note that U=
GENE 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.
- Create an empty database
Log in to the MySQL s=
erver 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`;
- Create database users
You may probably want to=
limit possible influence on the shared database by the UGENE users who wil=
l 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';
De=
cide 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 CREATE, SELECT, INSERT, INDEX, UPDATE, DELETE, CREATE ROUTINE, EXECUT=
E, DROP ON your_database_name.* TO `user_nickname`@'%' IDENTIFIED BY 'user_=
password';
and in the second case execute:
> GRANT SELECT ON =
your_database_name.* TO `user_nickname`@'%' IDENTIFIED BY 'user_passwo=
rd';
- Use the database from a UGENE instance
The dat=
abase with "your_database_name" is now available from a UGENE instance (ver=
sion 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 d=
ata to the database, use "user_nickname" and "user_password" of a user=
with privileges to modify the database. As soon as connection is establish=
ed, add the r=
equired data to the database.
From now on the data will be avail=
able for all users from this and other UGENE instances who connected to the=
same database.
------=_Part_88895_1658696719.1711698683201--