最近换了块固态盘，然后寻思着把分区重新搞一下，结果搞完分区之后忘了重新设置MySQL数据目录了，结果就是连接数据库一直失败，刚开始的错误就是这些，然后用navicat一直连不上数据库，用命令更是直接白给
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld.exe -hlocalhost -uroot -p
mysqld: Can't change dir to 'C:\Program Files\MySQL\MySQL Server 5.7\localhost\' (Errcode: 2 - No such file or directory)
-01-23T16:17:37.153194Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
-01-23T16:17:37.153281Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
-01-23T16:17:37.153862Z 0 [Note] mysqld.exe (mysqld 5.7.30) starting as process 9088 ...
-01-23T16:17:37.156938Z 0 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.7\localhost\PALA.lower-test
-01-23T16:17:37.157450Z 0 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.7\localhost\PALA.lower-test
-01-23T16:17:37.158469Z 0 [ERROR] failed to set datadir to C:\Program Files\MySQL\MySQL Server 5.7\localhost\
-01-23T16:17:37.158925Z 0 [ERROR] Aborting
-01-23T16:17:37.159388Z 0 [Note] Binlog end
-01-23T16:17:37.159758Z 0 [Note] mysqld.exe: Shutdown complete
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld.exe -uroot -p
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld.exe -remove mysql57
Service successfully removed.
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld.exe
mysqld: Can't read dir of 'G:\xxx\DATABASE\MySQL\Uploads\' (Errcode: 2 - No such file or directory)
-01-23T16:19:42.402237Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
-01-23T16:19:42.402555Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
-01-23T16:19:42.403307Z 0 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : G:/xxx/DATABASE/MySQL/Uploads
-01-23T16:19:42.403868Z 0 [ERROR] Aborting
-01-23T16:19:42.404252Z 0 [Note] Binlog end
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld.exe
^C
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld.exe
^C
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld.exe
在之前我就已经删了已经注册的MySQL服务了，因为那个服务的参数不正确，调好后再重新配置
用的命令：
mysqld.exe -remove mysql57
后来看到一个帖子
MySQL数据库之Mysql 5.7.19 免安装版遇到的坑(收藏)-职坐标/mysql-18122100202/说是拷一个新的my.ini文件到MySQL安装目录，修改basedir和datadir值，然后把my.ini文件放到C:\Program Files\MySQL\MySQL Server 5.7目录下面，和bin同级，由MySQL自己去识别。我这里当然是接着用之前可以的my.ini文件了，然后改了一下现在的数据目录，配置都是用的以前配置过的，就放到里面可以重新读取了
复制到里面后使用MySQL的mysqld.exe启动，用以前的密码连接，可以连了，然后再将服务安装到window10系统，以后就可以自动启动了
mysqld --install mysql57 --defaults-file="C:\Program Files\MySQL\MySQL Server 5.7\my.ini"
