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
Table of contents What are spread and rest operat...
<br />Original URL: http://www.lxdong.com/po...
Translucent border Result: Implementation code: &...
Table of contents 1. Primary key exists 2. No pri...
First, download the installation package from the...
1. Create a new configuration file docker_nginx.c...
As the first article of this study note, we will ...
Table of contents 1. jsonp cross-domain 2. docume...
1. The mysqldump backup method uses logical backu...
1. Download, install and activate CLion Just foll...
The mini program collected user personal informat...
The SQL query statement execution order is as fol...
I struggled with a problem for a long time and re...
Everyone must be familiar with table. We often en...
1. Create a centos7.6 system and optimize the sys...