mySQL的一些坑

坑1：服务启动不了

C:\Users\wuxx10>mysql -root -p
Enter password: *********
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

原因为D盘原先已经装过mysql 卸载后 重装到C盘了，需要再服务中删除后再重新加载C盘目录下的服务

C:\Users\wuxx10>sc delete MySQL
[SC] DeleteService SUCCESS

mysqld --install之后成功

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --install
The service already exists!
The current server installed: D:\1.Tools\001_programTools\005.MySQL\mysql-8.0.18-winx64\bin\mysqld MySQL

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --install
Service successfully installed.

执行启动服务net start mysql 遇到了坑2 出现Error 193

C:\Users\wuxx10>net start mysql
System error 193 has occurred.

*** is not a valid Win32 application.

把mysqld的文件干掉了，显示文件大小为0kb

坑3  IIS启动webservice 服务失败 

net start w3svc