Mysql error message language setting_mysql

When I set the Mysql error message language to operate the database today, the mysql error return statement always reports non-English language, which is a bit confusing and easy to guess, the complexity will be hard to understand. The following is a simple example:

[Err] 1064 - Erreur de syntaxe près de '2' à la ligne 1

So I searched a lot of information on the Internet and almost couldn't find the relevant information. I finally found a piece of information that was related to mysqld.

Finally, I found many language packs in the "share/" directory under the mysql installation directory.

Open my. ini and find

[mysqld]port=3306explicit_defaults_for_timestamp = TRUE

Find the [mysqld] Node and add the following sentence below

language=d:/wamp/bin/mysql/mysql5.6.17/share/english

Then restart

OK.

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1

Note:

d:/wamp/bin/mysql/mysql5.6.17/share/english

The directory path must be written as/. mysql cannot be started because of the write direction at the beginning.