MySQL Chinese garbled characters and mysql garbled characters

MySQL Chinese garbled characters and mysql garbled characters

MySQL Chinese garbled Processing

 

MySQL viewing code

• -H indicates the server name, And localhost indicates local;

• -U indicates the database user name, and root indicates the default mysql user name;

• -P indicates the password. If the password is set, you can directly enter it after-p.

3. Enter show variables like 'character _ set _ % '; // display the encoding settings of mysql.

 

Add a little knowledge:

MySQL enables and disables the Service (run cmd as an administrator)

• Net start * -- start the service

• Net stop * -- disable the service

  • * Replace mysql57 with the name of the service to be enabled (Case Insensitive );