[mysql]# 設置mysql客戶端默認字符集default-character-set=utf8[mysqld]# 設置3306端口port=3306# 設置mysql的安裝目錄basedir=D:/mysql-8.0.13-winx64# 設置mysql數據庫的數據的存放目錄datadir=D:/mysql-8.0.13-winx64/data# 允許最大連接數max_connections=200# 服務端使用的字符集默認為8比特編碼的latin1字符集character-set-server=utf8# 創(chuàng)建新表時將使用的默認存儲引擎default-storage-engine=INNODB

bin/mysqld --defaults-file=my.ini --initialize-insecure

use mysql;select host,user,authentication_string,plugin from user;alter user ‘root'@‘localhost' identified with mysql_native_password by ‘password';

update user set host='%' where user=‘root';flush privileges;exit;

net stop mysqlnet start mysql