mySQL的一些坑
程序员文章站
2022-07-15 16:44:47
...
坑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