In order, here are questions to answer in order to narrow down database problems.
| Table of Contents |
|---|
Is MySQL (or MariaDB) Server software installed?
Go to Start Menu, All Programs, and look for MySQL, which should have MySQL Server and MySQL Workbench. (Some computers may have MariaDB instead of MySQL.)
- If missing, install (directions).
Is the MySQL server running?
Try connecting using CSPM or MySQL Workbench.
...
- If MySQL is not there, it has not been properly installed. Uninstall and reinstall from new (hopefully you have a saved database backup file).
...
Go to CSPM, Options, Local settings; make sure the username, password, database name, and computer are correct. Click the Test button (see item 10 in cspm_local page).
Use "localhost" for the server name if you installed MySQL on your machine.
In SPM8, "sidata" was the usual name, and in SPM12, it's "sidata14".) Click the Test button (see item 10 in cspm_local
Is the database configured with the correct structure (the correct tables)?
Simplest is to open the CSPM Subjects GUI; if this fails, most likely the database structure has not been loaded (see restore/new page).