输入
mysqld -install
mysqld --initialize --user=root --console
定位到错误为:
unknown variable 'default-character-set=utf8'
找到配置文件:
设置[Server]下的'default-character-set=utf8'改为:
character_set_server=utf8
删除目录下的data文件夹
重新进入dos的命令行,一定要用administrator进入,执行:
mysqld --initialize --user=root --console
初始化了以后,可以看到MySQL目录下,多了data目录
- 启动MySQL服务
D:\Program Files\MySQL\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
- 使用默认生成的密码,进入mysql
D:\Program Files\MySQL\bin>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.10
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
- 3. 进入了mysql就可以修改默认密码了(我把默认密码修改成了root)
mysql> set password = password('root') ;
这个时候,Windows下的MySQL环境就已经安装好了。