Some of Mysql's exception fixes

First, about large file storage

1. When using MySQL to store large files, the exception

Add the following line to the configuration file

2. Restart MySQL after the change, but report the following error:

Solution:

My MySQL is version 5.6, found online said to modify the configuration file as follows:

，

Reference article: dot me

After the change and found that there is no egg use, it should be the MySQL version of the problem, my is 5.6

Later, Baidu changed again, the engine of the data sheet was changed from the default InnoDB

Reference article: dot me

Dot me!

3. Finally changed to, large files written in, but Chinese garbled, so we need to change the connection database configuration file :

Before the change:

After the change:

To run the program:

The problem is resolved

Some of Mysql's exception fixes