[mysql]
# 設置mysql客戶端默認字符集
default-character-set=utf8
?
[mysqld]
# 設置3306端口
port=3306
# 服務實例的唯一標識
# server_id = MySQL
# 設置mysql的安裝目錄
basedir=D:\\Program Files\\mysql-8.0.28-winx64
# 設置 mysql數(shù)據(jù)庫的數(shù)據(jù)的存放目錄，MySQL 8+ 不需要以下配置，系統(tǒng)自己生成即可，否則有可能報錯
# datadir=D:\\Program Files\\mysql-8.0.28-winx64\\data
# 允許最大連接數(shù)
max_connections=20
# 允許連接失敗的次數(shù)。這是為了防止有人從該主機試圖攻擊數(shù)據(jù)庫系統(tǒng)
max_connect_errors=10
# 服務端使用的字符集默認為utf8mb4
character_set_server=utf8mb4
# 創(chuàng)建新表時將使用的默認存儲引擎
default-storage-engine=INNODB
# 默認使用“mysql_native_password”插件認證
default_authentication_plugin=mysql_native_password
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M?

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES?

[mysql]
# 設置mysql客戶端默認字符集
default-character-set=utf8mb4

[client]
# 設置mysql客戶端連接服務端時默認使用的端口
port=3306 ??
default-character-set=utf8mb4

mysqld --initialize

Install/Remove of the Service Denied!

mysqld --install MySQL

mysql -uroot -p

mysql -u root -p '原來的密碼'?

show databases;

use mysql;

ALTER USER '用戶名'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密碼';

flush privileges; ?

exit;