MySQL常见问题

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博客