在解压目录新建一个文件my.ini
内容如下
[client]
port=3306
default_character_set=utf8
[mysqld]
port=3306
character_set_server=utf8
basedir=C:\Program Files (x86)\mysql-5.6.41-winx64
datadir=C:\Program Files (x86)\mysql-5.6.41-winx64\data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
C:\Program Files (x86)\mysql-5.6.41-winx64\bin\mysqld.exe
配置MYSQL_HOME和path
以管理员方式启动cmd.exe。然后依次执行如下命令,大功告成
cd C:\Program Files (x86)\mysql-5.6.41-winx64\bin
mysqld install MySQL --defaults-file="C:\Program Files (x86)\mysql-5.6.41-winx64\my.ini"
net start mysql
mysql -uroot
use mysql
update user set password=PASSWORD("123456") where user='root';
flush privileges;
quit;