In Windows, If you get the following error when you start MySQL service,
Could not start the MySQL service on Local Computer
Error 1067: The process terminated unexpectedly.
Then, follow the fix mentioned below.
1. Start >> Run >> type “cmd”.
2. Go to MySQL binary directory.
In my server, it is “C:\Program Files\MySQL Server 5.0\bin”.
3. Execute the following command “mysqld-nt.exe –console”. If it executes fine, then you need to check the file “my.ini”.
4. Edit the file “my.ini” with the following details and save it.
[mysqld]
port = 3306
basedir=”C:\Program Files\MySQL Server 5.0″
datadir=”c:\Program Files\MySQL Server 5.0\Data”
5. Now you can start MySQL service.
Could not start the MySQL service on Local Computer
Error 1067: The process terminated unexpectedly.
Then, follow the fix mentioned below.
1. Start >> Run >> type “cmd”.
2. Go to MySQL binary directory.
In my server, it is “C:\Program Files\MySQL Server 5.0\bin”.
3. Execute the following command “mysqld-nt.exe –console”. If it executes fine, then you need to check the file “my.ini”.
4. Edit the file “my.ini” with the following details and save it.
[mysqld]
port = 3306
basedir=”C:\Program Files\MySQL Server 5.0″
datadir=”c:\Program Files\MySQL Server 5.0\Data”
5. Now you can start MySQL service.
0 comments:
Post a Comment