Author: isenberg
Publication Date: 5/14/2014 13:36
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.
Tags: admindoc, connection, mysql
Comments
1 comment
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 .
Please sign in to leave a comment.