Configuring MySQL databases for HCL SafeLinx with DDL

This task describes how to use DDL scripts to create the HCL SafeLinx session and accounting databases on MySQL. DDL scripts are run on the remote server (Steps 3 - 7).

Procedure

  1. Copy the DDL scripts to the database server and change directory to where they were pasted.
  2. Edit the script to customize the location of files, size of the database, schema names, and so forth. After each command is entered you are prompted for the admin_ID password.
  3. Apply the DDL schema to the session database. From a command prompt, type the following command: 
    mysql -u admin_ID -p < "wgdata-create.sql"
  4. Optional: Create the accounting database. From a command prompt, type the following command: 
    mysql -u admin_ID -p < "wgacct-create.sql"
  5. Create the wgdb user. From a command prompt, type the following command: 
    mysql -u root -p -e "CREATE USER 'wgdb'@'%' IDENTIFIED WITH mysql_native_password BY 'Password'";
    Note: MySQL user names are case sensitive. Be sure the user created matches the grant statement.
  6. Grant the wgdb user ID permission to use the HCL SafeLinx database. From a command prompt, type the following command: 
    mysql -u admin_ID -p < "wgdata-grant.sql"
  7. If you created a wgacct database, run the script to grant the wgdb user ID permission to use it. From a command prompt, type the following command: 
    mysql -u admin_ID -p < "wgacct-create.sql"
  8. (Windows only) Run the Database Configuration Wizard to complete the database setup. For more information, see Completing the initial MySQL database configuration on Windows.

Results

You are now ready to run the SafeLinx Administrator and configure your SafeLinx Server.