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

There may be some errors when installing in MySQL 8.0.16 indicating that "UTF8B3" is no longer used but "UTF8B4" is used.

# / the following is the content in my.ini / /

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir= # remember to fill in # set the data storage directory of the mysql database (this directory will be generated later without handwriting) datadir=\ data # here remember to fill in # the maximum number of connections allowed max_connections=200# the number of connection failures allowed. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. The default storage engine default-storage-engine=INNODB# that UTF8B4character-set-server=utf8mb4# will use when creating new tables by default uses the "mysql_native_password" plug-in authentication default_authentication_plugin=mysql_native_password [mysql] # to set the mysql client default character set default-character-set=utf8mb4 [client] # setting. Set the port port=3306 default-character-set=utf8mb4 used by default when the mysql client connects to the server

Summary

The above is the MySql 8.0.16 version installation tips introduced to you by the editor, which no longer uses "UTF8B3" but uses "UTF8B4". I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

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.