The MySql 8.0.16 version installation prompts that "UTF8B4" is used instead of "UTF8B3"

The MySql 8.0.16 version installation prompts that "UTF8B4" is used instead of "UTF8B3"

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!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!

You may also be interested in:
  • mysql installer community 8.0.16.0 installation and configuration graphic tutorial
  • MySQL 8.0.16 installation and configuration method graphic tutorial under Windows
  • mysql 8.0.16 winx64.zip installation and configuration method graphic tutorial
  • MySQL 8.0.16 compressed package installation and configuration method graphic tutorial
  • The latest graphic tutorial of mysql 8.0.16 winx64 installation under win10
  • MySQL 8.0.16 installation and configuration tutorial under CentOS7

<<:  Solution to the problem that docker logs cannot be retrieved

>>:  Using js to implement the two-way binding function of data in Vue2.0

Recommend

Solve the problem of Syn Flooding in MySQL database

Syn attack is the most common and most easily exp...

Operate on two columns of data as new columns in sql

As shown below: select a1,a2,a1+a2 a,a1*a2 b,a1*1...

Vue project code splitting solution

Table of contents background Purpose Before split...

Methods and steps to build nginx file server based on docker

1. Create a new configuration file docker_nginx.c...

Summary of how to use bootstrap Table

This article shares with you how to use bootstrap...

Best Practices Guide for MySQL Partitioned Tables

Preface: Partitioning is a table design pattern. ...

js to realize the rotation of web page pictures

This article shares the specific code of js to re...

Solve the error "Can't locate ExtUtils/MakeMaker.pm in @INC"

When installing mha4mysql, the steps are roughly:...

Detailed explanation of long transaction examples in MySQL

Preface: The "Getting Started with MySQL&quo...

Detailed explanation of Linux netfilter/iptables knowledge points

Netfilter Netfilter is a packet processing module...

Example of downloading files with vue+django

Table of contents 1. Overview 2. Django Project 3...

Detailed explanation of MySQL transaction isolation level and MVCC

Table of contents Transaction Isolation Level Pro...

Detailed explanation of Mysql transaction isolation level read commit

View MySQL transaction isolation level mysql> ...