1. 下载(免安装)
2. 安装
新建my.ini在mysql的安装目录
[client]
port=3306
default-character-set=utf8mb4
[mysqld]
port=3306
character_set_server=utf8mb4
basedir=E:\WorkSoft\MySQL8
datadir=E:\WorkSoft\MySQL8\data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
default-storage-engine=InnoDB
[WinMySQLAdmin]
E:\WorkSoft\MySQL8\bin\mysqld.exe
mysqld.exe --initialize --console
mysqld.exe --install(安装mysql服务)
切记要记住密码:
3. 修改密码
>alter user "root"@"localhost" identified by "你的密码";
4. 修改任意ip登录
select user,host,authentication_string from mysql.user;
update mysql.user set host='%' where user='root'
flush privileges;