Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

In order, here are questions to answer in order to narrow down database problems.

Is MySQL (or MariaDB) 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.)

Is MySQL running?

Try connecting using CSPM or MySQL Workbench.

If that fails, see if the "service" is running: at the start menu, type "services" and click on the ...Window services icon

Check there there is a service named MySQL, and that its status is "Started."

  • If MySQL is not there, it has not been properly installed. Uninstall and reinstall from new (hopefully you have a saved database backup file).
Can you connect to the database in Workbench?

Open MySQL Workbench, click on the gray box ("Local instance MySQL")

Can you connect to the database in CSPM?

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".

 

T

 

 

  • No labels