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:

SHOW VARIABLES LIKE 'character_set_%';

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

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!