Mysql Error code:1436 Thread Stack overrun_mysql

errno:256
TEXT:SQLSTATE[HY000]: General error:1436 Thread stack overrun:4904 bytes used of a 131072 byte stack, and 128000 bytes Needed. Use the ' Mysqld-o thread_stack=# ' to specify a bigger stack.

According to the MySQL manual "the default (192KB) are large enough for normal operation. If the thread stack size is too small, it limits the complexity of the SQL statements this server can handle, the RECU Rsion depth of stored procedures, and other memory-consuming actions.

To resolve this issue your need to change the default value of parameter ' Thread_stack ' in/etc/my.cnf in your MySQL confi Guration file. I use the XAMPP for Php/mysql development.

Once you are set this value for your need to restart MySQL as this value cannot is set dynamically.

You are maybe also encounter with the "when" you try to modify the MY.CNF

"Cannot open file for Writing:permission denied"

We'll try to use the ' chmod ' instruction to change permission as usually. I seldom take the concrete permission into consideration and so I use always to use the ' chmod 777 '. But it resulted in another errors where I use the phpMyAdmin, another tools included in XAMPP, after running ' chmod 777 '.

After Googling it, I get this file (MY.CNF) permissions has to be 600. I change its permission and it works.