1.新建my.ini(注意文件編碼)

[mysql]

port = 13307

default-character-set=utf8mb4

[mysqld]

port = 13307

basedir=D:\mysql-8.0.14-master

datadir=D:\mysql-8.0.14-master\data

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

character-set-server=utf8mb4

performance_schema_max_table_instances=600

table_definition_cache=400

2:mysqld --defaults-file=D:\mysql-8.0.14-slave\my.ini --initialize --console

3.mysqld install mysql_slave --defaults-file="D:\mysql-8.0.14-slave\my.ini"

des:忘記密碼

? ? ?新建Repweat_pwd.txt??

? ? ?Repweat_pwd.txt內(nèi)容:

? ?ALTER user root@'localhost' identified by '密碼';

?4.mysqld --defaults-file="D:\mysql-8.0.14-slave\my.ini" --init-file="D:\mysql-8.0.14-slave\Repweat_pwd.txt"

使用123456密碼登錄，進(jìn)入修改

!!! 移除服務(wù)：mysqld -remove? 名字

5.開(kāi)啟遠(yuǎn)程服務(wù)

CREATE USER 'root'@'%' IDENTIFIED BY '密碼';

GRANT ALL ON *.* TO 'root'@'%';

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密碼';

FLUSH PRIVILEGES;