isenberg
I'm new here

Configuration of Mysql Database

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.

Comments

Before deciding to use MySQL instead database systems like Postgresql, Oracle, Microsoft SQL-Server or IBM DB2, please take a look at its limitations in https://community.e-spirit.com/docs/DOC-1816 .