Delete the certificate from the database:
- Click Start, Run, type cmd, and press Enter.
- Change directory to the <database>\bin directory:
- For Manager 9.1.7.75 and earlier:
Type cd <$install_directory>\MySQL\bin\ and press Enter.
- For Manager 9.1.7.77 and later, including 10.x and 11.x:
Type cd <$install_directory>\MariaDB\bin and press Enter.
- Type the following command and press Enter:
mysql -u<user> -p<password> <database>
For example:
mysql -uroot -proot123 lf
- Obtain the <key_id> using the <cert_name>.
Type select key_id,cert_name from iv_ssl_key; and press Enter.
- Use the <key_id> to delete the expired certificate.
Type the following command and press Enter. Replace XXXX with expired certificate <key_id>.
delete from iv_ssl_key where key_id=<XXXX>;
- Restart the Manager Service.
