Views: 2042 (Data available since 06.02.2017)

Note: If the product is installed jointly with Bitrix Web Environment, this step will be skipped.

Here the database connection configuration file is created; the database is populated with data. The fields in the Database settings group vary depending on the chosen database type. Other fields are common to all databases.

MySQL database parameters

At this point, the database connection parameters are established.

Local installation

If you install Bitrix24 on a local machine and have the required applications (Apache, PHP, MySQL), or Bitrix Web Environment installed:

  • Server: the address of a server that hosts the database engine (MySQL in this case). This value is usually "localhost" for local servers, and the port number in the format localhost:[port]. You can find the port number in the MySQL configuration files.

    Note: When installing Bitrix24 on Bitrix Web Environment, type localhost:31006 in this field.

  • Database user: select to create a new user;
  • User name: type here any desired database user name (login) that will be used to access the database.
  • Password: the database user password.
  • Database: select to create a new database.
  • Database tables type: standard tables are generally good for most use cases:
    • Standard. Standard type of tables in MySQL is MyISAM that is not transaction-oriented. For MyISAM-type tables, all data are saved in one file and, therefore, the maximum size of the file is at the same time the maximum size of the table.

      Operating systems impose their limits on the maximum size of the file. Normally it ranges from 2 to 4 Gb. MyISAM tables are platform independent. Table files may be transferred between computers of various architectures and various operating systems without any conversion.

    • Innodb. InnoDB tables in MySQL are equipped with a table handler ensuring safe transactions with the possibilities of transaction fixing, rollback, and recovery after a failure.

      Row-level lock is used in InnoDB tables together with the read method without locking in the SELECT command. The transaction log is kept in case transactions are cancelled. It is subject to internal rotation, i.e. when all the records are filled, the oldest records start getting removed. These functions permit improving mutual compatibility and enhancing performance in multi-user mode.

      InnoDB is intended to receive maximum performance when processing high volumes of data. In terms of the efficient use of the processor, this type by far exceeds other models of relational databases with memory on disks.

  • New database: the name of the database to which the product will be installed.
    A new group of fields will appear: Database administrator parameters.

  • Type root in the Login field.
  • The Password field must be empty

Remote Server

If you install Bitrix24 on a remote server, consult the hosting service provider for the database parameters. Specifically, you should obtain values for the following fields:

  • Server address;
  • Database user: consult whether you need to create a new database user;
  • (database) User name;
  • (database) Password;
  • Database: consult whether you need to create a new database;
  • Database name;
  • Type of database tables.

Standard tabled are optimum for most cases. However, web shops are observed to perform better with InnoDB tables.

Note: If you need to create a new database user or a new database, the database user name and password fields are required. If no database exists yet, you must create a new one (by selecting the appropriate option). However, new databases are usually created by the hosting service techsupport. You will only have to obtain the user name, password and connection parameters.

Oracle database parameters

Attention: Before proceeding with the installation, the web server environment has to be set up: environment variable NLS_LANG must establish CP1251 encoding (for example, NLS_LANG=ENGLISH.CP1251), and decimal separator must be “.” – NLS_NUMERIC_CHARACTERS=.
  • Connection string: this field should contain either the name of a local Oracle instance, or the record name in tnsnames.ora to connect to. Example of the name of a local Oracle instance:
    (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 000.000.0.00)(PORT = 0000)))(CONNECT_DATA = (SERVICE_NAME = BX)))
  • Database user: if checked, a new database user will be created. Otherwise, an existing user will be used.
  • User: a user name (login) of the database user used to access the database.
  • Password: a user password to access the database.
Note: If you choose to create a new database or database user, you will have to provide the database administrator's login and password. The database administrator's user name and password are used only at the installation and database creation time. This information is not stored in the system.

Attention: Oracle full client, and not a RunTime client version, must be installed on the web server without fail.

MSSQL database parameters

  • DSN: a database connection string. The string should contain, at least, the connection driver parameters and the server name. Optionally, you can include the user name, password or other parameters.
  • Note: Sometimes you would need to specify a user DSN name here (a connection must be created in advance). For local servers (if the product is installed on the same server as the database), this parameters usually has a value of localhost.

  • Database user: if checked, a new database user will be created. Otherwise, an existing user will be used.
  • User: a user name (login) used to access the database.
  • Password: a user password to access the database.
  • Create database: check this option if you want to create a new database.
  • Database name: type the name of the database to which the system will be installed.
  • Note: If you choose to create a new database or database user, you will have to provide the database administrator's login and password. The database administrator's user name and password are used only at the installation and database creation time. This information is not stored in the system.


Additional parameters

These parameters define permissions to assign to all files and folder of the site. They are common to all database types.

  • File access permissions: Permissions that will be applied to all newly created files. Access permissions should allow the web server to write to files. The default value is 0644;
  • Folder access permissions: Permissions that will be applied to the newly created folders. Access permissions should allow the web server to write to folders. The default value is 0755.

Note: you can alter the database connection parameters manually by editing the file /bitrix/php_interface/dbconn.php which is created upon installation.

Click Next to continue.



Courses developed by «Bitrix», Inc.