CODEWITHSUNDEEP
mysql
subzeroLV
subzeroLV

Reputation: 73

MySQL query action output language

I'm hoping this is a simple question. I recently installed MySQL Workbench, and thought everything was going fine, until I noticed the output of messages at the bottom. They're in a foreign language. See attached screenshot. I tried the same queries in phpMyAdmin and get similar results.

Server connection collation: utf8mb4_general_ci (I tried to change to utf8_general_ci but it won't let me)

Any help is greatly appreciated.

Upvotes: 0

Views: 271

Answers (1)

Edper
Edper

Reputation: 9322

Try changing your my.ini file to the following:

lc-messages=en_US

or run the command prompt and in the mysql prompt do:

SET lc_messages = 'en_US';

Check the following reference

Upvotes: 1

Related Questions