When installing in MySQL 8.0.16, some errors may appear, indicating that "UTF8B4" is used instead of "UTF8B3". #//////////////////////The following is the content of my.ini//////////////////////// [mysqld] # Set port 3306 port=3306 # Set the installation directory of MySQL basedir= #Remember to fill in here# Set the storage directory of MySQL database data (this directory will be generated by commands later, no need to write it manually) datadir= \data #Remember to fill in the maximum number of connections allowed max_connections=200 # The number of connection failures allowed. This is to prevent someone from trying to attack the database system from this host max_connect_errors = 10 # The default character set used by the server is UTF8B4 character-set-server=utf8mb4 # The default storage engine that will be used when creating a new table default-storage-engine=INNODB # By default, the "mysql_native_password" plug-in is used for authentication. default_authentication_plugin=mysql_native_password [mysql] # Set the default character set of the mysql client to default-character-set=utf8mb4 [client] # Set the default port used by the mysql client to connect to the server port=3306 default-character-set=utf8mb4 Summarize The above is the problem that the installation prompt of MySql 8.0.16 version no longer uses "UTF8B3" but "UTF8B4" introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website! You may also be interested in:
|
<<: Solution to the problem that docker logs cannot be retrieved
>>: Using js to implement the two-way binding function of data in Vue2.0
Syn attack is the most common and most easily exp...
There is a business that queries the 5 most recen...
As shown below: select a1,a2,a1+a2 a,a1*a2 b,a1*1...
Table of contents background Purpose Before split...
1. Create a new configuration file docker_nginx.c...
This article shares with you how to use bootstrap...
Preface: Partitioning is a table design pattern. ...
This article shares the specific code of js to re...
There is a project developed on Mac, and the pack...
When installing mha4mysql, the steps are roughly:...
Preface: The "Getting Started with MySQL&quo...
Netfilter Netfilter is a packet processing module...
Table of contents 1. Overview 2. Django Project 3...
Table of contents Transaction Isolation Level Pro...
View MySQL transaction isolation level mysql> ...