The method of modifying mysql character set in the console

Xiaobian to share with you in the console to modify the mysql character set method, I believe most people do not know how to share this article for your reference, I hope you read this article after a great harvest, let us go to understand it!

Methods to modify mysql character set on console: 1. Open command prompt;2. Log in mysql by executing mysql -uroot -p;3. Modify character set by executing alter database mydb character set utf8;.

Specific methods:

1. Modify the database character code

mysql> alter database mydb character set utf8;

When creating a database, specify the character encoding of the database

mysql> create database mydb character set utf8 ;

3. Check the character encoding of mysql database

mysql> show variables like 'character %';//Query the character encoding of all attributes in the current mysql database

The above is all about how to modify mysql character sets in the console. Thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!