I'm new here

Configuration of Mysql Database

Configuration of Mysql Database for FirstSpirit

This addendum complements:

    PDF: FirstSpirit Manual for Administrators

    Chapters: MySQL databases


FirstSpirit Server and Mysql Server are installed on the same host and the connection to Mysql fails, although all configuration parameters are set correctly.


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.


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 .