Prerequisites
Before you assign rights to the accounts, perform the following actions:
Configuring the accounts to install Administration Server
To configure the accounts for the Administration Server installation:
GRANT OPTION
)SELECT
, SHOW VIEW
EXECUTE
PROCESS
, SUPER
To create an internal DBMS account and grant the required privileges to this account, run the script below (in this script, the DBMS login is KSCAdmin, and the Administration Server database name is kav):
/* Create a user named KSCAdmin */
CREATE USER 'KSCAdmin'
/* Specify a password for KSCAdmin */
IDENTIFIED BY '<
password
>';
/* Grant privileges to KSCAdmin */
GRANT USAGE ON *.* TO 'KSCAdmin';
GRANT ALL ON kav.* TO 'KSCAdmin';
GRANT SELECT, SHOW VIEW ON mysql.* TO 'KSCAdmin';
GRANT SELECT, SHOW VIEW ON sys.* TO 'KSCAdmin';
GRANT EXECUTE ON PROCEDURE sys.table_exists TO 'KSCAdmin';
GRANT PROCESS ON *.* TO 'KSCAdmin';
GRANT SUPER ON *.* TO 'KSCAdmin';
If you use MariaDB 10.5 or earlier as a DBMS, you do not need to grant the EXECUTE privilege. In this case, exclude the following command from the script: GRANT EXECUTE ON PROCEDURE sys.table_exists TO 'KSCAdmin'
.
SHOW grants for 'KSCAdmin';
CREATE DATABASE kav
DEFAULT CHARACTER SET ascii
DEFAULT COLLATE ascii_general_ci;
Use the same database name that you specify in the script that creates the DBMS account.
The Administration Server Setup wizard starts. Follow the instructions of the wizard.
You can select an existing Windows user account or automatically create a new Windows account in the KL-AK-* format by using the installer. Regardless of the account choice, the installer assigns the required system rights to the Administration Server service account.
After the installation finishes, the Administration Server database is created and Administration Server is ready to use.