How to set MySql encoding format using command line

How to use the command line to set the MySql encoding format: first log in to mysql and enter [SHOW VARIABLES LIKE 'character_set_%']; then check whether the value value is utf8, if not, use SET settings; finally complete Can.

The operating environment of this tutorial: Windows 7 system, mysql version 8.0. This method is suitable for all brands of computers.

Related free learning recommendations: mysql database(Video)

##Use How to set the MySql encoding format on the command line:

1. Log in to mysql

2. Enter

SHOW VARIABLES LIKE 'character_set_%';

3. Check whether the value is utf8, if not, use SET to set it.

4. Enter

SHOW VARIABLES LIKE 'character_set_%'; Check again to confirm.

5.Finally exit; Complete

The above is the detailed content of How to set MySql encoding format using command line. For more information, please follow other related articles on the PHP Chinese website!