1、命令行插入中文失败:set charset gbk;
2、SQL 的执行顺序
3、安装多个MySQL服务时,A服务的可执行路径是B服务的路径,导致客户端连接不上A服务
1、查看服务的路径:
2、修改路径:
Open registry editör (regedit.exe) then find mysql service (HKLM --> SYSTEM --> CurrentControlSet --> Services --> MySQL) and correct the ImagePath setting.
Updating the path to MySQL in regedit in Windows 10 {Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL}
Alternatively you can search for c:\Program Files\MySQL\mysqld in registry and change to C:\Program Files\MySQL\MySQL Server 5.1\bin
Then run in cmd (admin mode)
cd C:\Program Files\MySQL\MySQL Server 5.1\bin
mysqld.exe --initialize
open services and start mysql service OR
run: net start mysql
如何更改mysql服务,如何更改mysql服务的路径_我就是摘星星的少年的博客-CSDN博客