MySQL - Error code 2013. Lost connection to MySQL server during query I did check other posts. Change timeout value...does not help. its something with the server. It seems each time if I trying to insert sth out range, the server just collapse. Its my localhost, Server on my own computer.
Tried to drop a table or other things. None of the code would work.
Restart the computer would work again, but I'd rather not to to that each time I run into problem.
None of the code in Workbench would work, all come back with Error code 2013...
mysql.connector.errors.DataError: 1264 (22003): Out of range value for column 'total_revenue' at row 1
23:02:40    DROP TABLE `a_share`.`income_statement` Error Code: 2013. Lost connection to MySQL server during query  30.000 sec
23:03:51    DROP TABLE `a_share`.`income_statement` Error Code: 2013. Lost connection to MySQL server during query  30.000 sec
Nerver mind. I found solution.
The server crashed on errors, changing any preference would not help.
you gota press WINDOWS + R
and type in Services.msc
Find MySQL80
right click to reboot the server.