I am engaged in installing zumro CRM . The server is configured. Now requirements for configuring the database :

**Failed Required Services** Database default collation is: utf8_general_ci . Database default collation should not be in: utf8_general_ci FAIL Database log_bin=on. Either set log_bin=off or set log_bin_trust_function_creators=on. FAIL **Failed Optional Services** Database max_sp_recursion_depth size is: 0 minimum requirement is: 20 FAIL Database thread_stack value is: 196608 minimum requirement is: 524288 FAIL Database optimizer_search_depth value is 62. It is required to be set to 0. FAIL Database does not support LOAD LOCAL INFILE. FAIL

I saw max_sp_recursion_depth in tables with configs, but you cannot change it.

Where to find and adjust all this?

Thank you in advance.

  • For such developers it is necessary to beat, IMHO. The reasonable requirement of thread_stack when requesting recursive stored procedures and the max_sp_recursion_depth setting itself. And this is all insisted in the server configs. Why can't you change? - Vesper

1 answer 1

MySQL directives are set in the my.cnf configuration file (my.ini for Windows). In the case of Linux, this file should be searched in /etc/my.cnf or /etc/mysql/my.cnf, sometimes it can be placed in the / var / lib / mysql data directory.

If you cannot find it, you should search the mysqld process list and see if the path to this file is passed in the parameters to the server.

 ps aux | grep mysqld

Alternatively, you can simply search on the hard disk.

 find / -name my.cnf -print

If the file is nowhere to be found, you can simply create it (preferably along the path /etc/my.cnf).

Inside the file is divided into sections, the beginning of which is denoted by the name enclosed in square brackets. The section specifying server directives is called [mysqld] . If inside the section there is no directive you need, you can safely start it. Changes take effect after server restart.