[KB7809] Create a database and database user for ESET PROTECT On-Prem (Windows)

Issue

• Create a database in Microsoft SQL or MySQL for the ESET PROTECT Server installation
• Create a dedicated database user for Microsoft SQL or MySQL

Details

Solution

• Create a dedicated database and database user for ESET PROTECT On-Prem in Microsoft SQL
• Create a dedicated database and database user for ESET PROTECT On-Prem in MySQL

Create a dedicated database and database user for ESET PROTECT On-Prem in Microsoft SQL

Prerequisites

• Administrative access to the operating system
• Installed and properly configured a supported Microsoft SQL Server
• Installed Microsoft SQL Server Management Studio
• Access to a Microsoft SQL administrator account and Microsoft SQL Server Management Studio

Create a database for ESET PROTECT On-Prem in Microsoft SQL

1. Open Microsoft SQL Server Management Studio and log in with your administrator account.

2. In Object Explorer, right-click Databases and select New Database from the context menu.

3. In the Database name field, type the database name. For example, use the default ESET PROTECT On-Prem database name era_db.

   Remember the database name

   Remember or record the database name, as you will need it later during the ESET PROTECT Server installation and database connection setup.

4. Click OK.

Create a dedicated database user for ESET PROTECT On-Prem in Microsoft SQL and assign it to the dedicated database

1. Open Microsoft SQL Server Management Studio and log in with your administrator account.

2. In Object Explorer, right-click Security and click New → Login.

3. In the Login name field, type the user account name. For example, use the default ESET PROTECT On-Prem database username era_user.

4. Select SQL authentication and type and confirm the user account password.

5. In the left-side menu, click User Mapping and select the check box next to the database you created. The user account name should appear in the User column next to the selected database.

   

6. Below Database role membership, select the check box next to db_owner and click OK.

   

Create a dedicated database and database user for ESET PROTECT On-Prem in MySQL

Prerequisites

• Administrative access to the operating system
• Installed and properly configured a supported MySQL Server
• Access to a MySQL administrator account; this article uses HeidiSQL as the administration tool, but you can use a different MySQL client or the command line

Create a database for ESET PROTECT On-Prem in MySQL

1. Open your MySQL administration tool and log in to the local database using the root account and password. Set the hostname to 127.0.0.1. Click Open.

2. Right-click the database root and select Create new → Database from the context menu.

   

3. In the Name field, type the database name. For example, use the default ESET PROTECT On-Prem database name era_db. Click OK.

Create a dedicated database user for ESET PROTECT On-Prem in MySQL and assign it to the dedicated database

1. Open your MySQL administration tool and log in to the local database using the root account and password. Set the hostname to 127.0.0.1. Click Open.

2. Click Tools → User manager.

   

3. Click Add → User.

   

4. Provide the user details:

   • In the User name field, type the username. For example, use the default ESET PROTECT On-Prem database username era_user.
   • In the From host drop-down menu, select Access from everywhere or type %.
   • In the Password and Repeat password fields, type the password.
     
     

     

5. Click Add object, select the database you created and click OK.

   

6. Below Privileges, select the check box next to the created database and deselect SHOW VIEW, EVENT, REFERENCES, and GRANT, so that the following privileges are selected:

   • EXECUTE
   • SELECT
   • ALTER
   • ALTER ROUTINE
   • CREATE
   • CREATE ROUTINE
   • CREATE TEMPORARY TABLES
   • CREATE VIEW
   • DELETE
   • DROP
   • INDEX
   • INSERT
   • TRIGGER
   • UPDATE
   • LOCK TABLES
     
     

   

7. Click Save.

   

8. Ensure the user you created is selected in the left-side menu and click Clone. For the user to be cloned, in the From host drop-down menu, select Access from server location only or type localhost. In the Password and Repeat password fields, type the password. Click Save.

   

You have created two database users with the same username: one allowing connections from any host and one restricted to localhost only.