Configuration of Mysql Database for FirstSpirit
This addendum complements:
PDF: FirstSpirit Manual for Administrators
Chapters: 4.8.5.2 MySQL databases
Problem:
FirstSpirit Server and Mysql Server are installed on the same host and the connection to Mysql fails, although all configuration parameters are set correctly.
Solution:
Add connection privilege to connections from localhost. Open a terminal to the host and enter, usually as root:
bash$ mysql
mysql> GRANT ALL PRIVILEGES ON <dbname>.* TO <dbuser>@localhost IDENTIFIED BY "<password>";
Depending on your mysql configuration and operating system, parameters -u root -p must be added to the command mysql.
