Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.