Completing the MySQL configuration record after Wamp installation

Note: Without special instructions, the default is to modify the My.ini configuration and the MySQL service will need to be restarted after modifying the configuration.

1, after installing WAMP after the input command has garbled hint:

The error message that occurs when you run the MySQL command is garbled: Error 1064 (42000): Erreur de syntaxe près de ' su mysql ' à la ligne 1

Open the Wamp\bin\mysql\mysql5.6.17\my.ini configuration file under the Wamp directory, and under the last line [mysqld] node, add the Red section, specifying the language pack for the prompt language

[Mysqld]
port=3306
Explicit_defaults_for_timestamp = TRUE

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

2. MySQL ignores the case:

[Mysqld]

Lower_case_table_names=1

3. Set MySQL encoding format:

[Client]

　　Default-character-set=utf8

[Mysqld]

　　Character_set_server=utf8

[MySQL]

Character_set_server=utf8

Completing the MySQL configuration record after Wamp installation