Dell Storage Manager 2020 R1 Administrator's Guide

Clean up a MySQL Database

Remove Dell Storage Manager data from the MySQL database and reinstall the Data Collector.

1. Enter the following SQL commands as an Admin user:

   Drop Database compmsadb;
   DELETE FROM mysql.user WHERE User = 'compmsauser';
   DELETE FROM mysql.db WHERE user = 'compmsauser';
   FLUSH PRIVILEGES;

2. Reinstall the Storage Manager Data Collector.