The creation of an Administrator or root account is required as part of MS SQL or MySQL installation. It is not recommended to use sa / root
(database administrator) account for ESET PROTECT Server to connect the database. You should create a dedicated database user as well as a dedicated database.
era_db
.era_user
.Figure 1-1
Open your MySQL administration tool and log in to the local database using the root account and password. Set the Hostname as 127.0.0.1.
Click Open to open your session. Right-click the database root and select Create new → Database from the context menu.
Figure 2-1
era_db
. Click OK.Open your MySQL administration tool and log in to the local database using a root account.
Set the Hostname to 127.0.0.1.
Click Tools → User manager.
Figure 2-2
Click Add and provide the details about the new database user:
era_user
.Figure 2-3
Figure 2-4
Under Allow access to, select the new database and mark the following properties:
Click Save to confim the user settings.
Figure 2-5
Figure 2-6
In the end, you have two users with the same name - a user with access from anywhere and a user with localhost access only.