Why can't I type Russian letters in mysql?

Question

linux

mysql is installed in ubuntu server. I connect to it via putty. When I open the terminal, Russian letters are written, and after opening, sudo mysql -u root -pthen Russian letters are not printed further. I want to make a request with Russian letters.

Answer 1

To make a request with Russian letters, you need to log in not as a root, but under a normal account.
Under root, the default encoding will be used in the console, and before version 8.0 it is Latin1, in which there are no Russian letters.
When logged in as a normal user, the mysql console will automatically pick up the current encoding of the command line client.

Answer 2

You need to look at the [mysqld] section in the my.cnf file.
Specifically, the parameters are:

character-set-server
collation-server