user2690457 user2690457 - 1 year ago 125
SQL Question

How to change the path of mysql services

After installation of MySQL 5.1.73, I've added the path variable to

C:\Program Files\MySQL\MySQL Server 5.1\bin

And I tried in the command line:

"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --install

It shows:

The service already exists!
The current server installed: "c:\Program Files\MySQL\mysqld" --defaults-file=my.ini MySQL

But as you can see the path I set is "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" but not "c:\Program Files\MySQL\mysqld" So no doubt when I type:

net start mysql

I get:

System error 2 has occurred.

The system cannot find the file specified.

How to change the strange wrong directory? I've never set this wrong directory before. My platform is Windows 7 Enterprise

Answer Source

Open registry editör (regedit.exe) then find mysql service (HKLM --> SYSTEM --> CurrentControlSet --> Services --> MySQL) and correct the ImagePath setting.

Alternatively you can search for c:\Program Files\MySQL\mysqld in registry and change to C:\Program Files\MySQL\MySQL Server 5.1\bin

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download