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.
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.
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.
Click Add and provide the details about the new database user:
Under Allow access to, select the new database and mark the following properties:
Click Save to confim the user settings.
In the end, you have two users with the same name - a user with access from anywhere and a user with localhost access only.