SIEM, Vulnerability Scanning, Server Monitoring and Compliance Training for IT Professionals
Table of Contents

MySQL Data Provider Properties

The Data Provider Properties view enables you to view and modify a Data Provider's settings.

In this Topic

How To View or Modify a MySQL Data Provider:

  • Use the Server text box to specify the hostname the MySQL database is installed.
Note
If the database is installed on the localhost, specify localhost.
  • Use the Database text box to specify the database.
  • Use the Username text box to specify the MySQL username.
  • Use the Password text box to specify the MySQL user's password.
  • Use the Connection timeout text box to specify the maximum time to wait for an available connection in the connection pool before timing out.
  • Use the Execution timeout text box to specify the maximum time to wait for SQL statements to complete before timing out.
  • Check Hash Mode to add hashing to each saved log entry often used in Italy to fulfill government compliance requirements.
  • Use the Batch size drop-down to specify the number of entries to to batch insert into the log databases.
  • Click the Test button to check the settings.
  • Click the Save button to save the settings.
Note
When saving a Log Database or Log Archive Database, if the database does not exist, the database and several tables are automatically created.
  • Click Delete to permanently delete this object.
Important
Log Database and Archive Log Database objects cannot be deleted.
MySQL Properties View
MySQL Properties View

How to Move the MySQL Databases to Another Location

  • Open the Windows Services Control Panel.
  • Stop the Corner Bowl Server Manager service.
  • Stop the MySQL80 service.
  • Run Notepad as an Administrator then open the following file:
    C:\ProgramData\MySQL\MySQL Server 8.0\my.ini
  • Search for datadir
  • Set the datadir value to your new location, for example:
    D:\MySQL Server 8.0\Data
Important
Windows Services cannot access mapped drives. If you want the database to reside on a NAS or other network device, specify the UNC path to the destination directory.
  • Move all of the files from the previous location to the new location.
  • Open the Windows Services Control Panel.
  • Start the MySQL80 service. If the service fails to start:
    • Verify the existence of the path.
    • If the path is a remote location, verify the path is using a UNC path rather than a mapped drive. Windows Services cannot access shares that have been mapped to a user�s account.
    • Verify the path�s permissions.
  • Start the Corner Bowl Server Manager service.
  • Open the Corner Bowl Server Manager Management Console.
  • Open the Dashboard, then from the General Tab, verify the Log Database and Archive Log Database display database detail.

Related Topics

Data Providers

Data Provider Properties

Database Monitoring Templates