相关资源下载首先,必做的第一件事情,先停止mysql服务,在服务里面停止即可,也可以用cmd命令停止,我是直接从服务里面停止的如下:
QQ截图20170525093730.jpg (64.59 KB, 下载次数: 284)
2017-5-25 09:40 上传
我的mysql安装目录:C:\Program Files\MySQL\MySQL Server 5.7\bin\,
我根据网上的教程,用cmd命令,cd进入到mysql的bin文件夹,然后执行:
QQ截图20170525092807.jpg (143.41 KB, 下载次数: 291)
2017-5-25 09:42 上传
mysqld: Can't change dir to 'C:\Program Files\MySQL\MySQL Server 5.7\data\' (Errcode: 2 - No such file or directory)
2017-05-25T01:26:39.139544Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-05-25T01:26:39.139544Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-05-25T01:26:39.142318Z 0 [Note] mysqld (mysqld 5.7.17) starting as process 11960 ...
2017-05-25T01:26:39.161559Z 0 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.7\data\DESKTOP-7IAJK37.lower-test
2017-05-25T01:26:39.162538Z 0 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.7\data\DESKTOP-7IAJK37.lower-test
2017-05-25T01:26:39.163179Z 0 [ERROR] failed to set datadir to C:\Program Files\MySQL\MySQL Server 5.7\data\
2017-05-25T01:26:39.163179Z 0 [ERROR] Aborting
2017-05-25T01:26:39.163179Z 0 [Note] Binlog end
2017-05-25T01:26:39.163179Z 0 [Note] mysqld: Shutdown complete
不按套路出牌啊!!!
哈哈,网上许多教程都是错误的,当我们执行“mysqld --skip-grant-tables”这句话的时候,mysql就会从bin的上级目录下面找my.ini 和 data文件夹,
由于,mysql 5.7安装的时候,改变了数据库data和my.ini配置文件夹的目录了,并不是和我们的bin文件夹在同一目录下面。
在第一张图里面,在mysql服务有一个很重要的参数:
密码随便输入即可!!密码随便输入即可!!密码随便输入即可!!
QQ截图20170525093651.jpg (62.29 KB, 下载次数: 292)
2017-5-25 09:42 上传
我们成功进入!
5:执行如下命令: