Windows – cannot start thesql 5.1 windows service under normal user account

MySQLserviceuserswindows

MySQL 5.1 service can start under Local System account or Administrator User account.
But MySQL 5.1 service cannot start under normal user account.

It gives:

Error 1067:The process terminated unexpectedly.

What could be the issue?

Best Answer

The most important thing is giving security permissions to normal user on MySQL Data folder.
Here is another simple way to solve the problem.

  1. Create a new user group. eg. MySQL_Admins
  2. Create a new user. eg. Mysql_user
  3. Add Mysql_user under MySQL_Admins group.

  4. Add following security permissions to MySQL_Admins on MySQL Data folder (you can find it in my.ini file)
    Windows XP
    datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/data"

    Windows Server 2008
    datadir="C:/ProgramData/MySQL/MySQL Server 5.1/data"

    a. Read & execute
    b. List folder contents
    c. Read
    d. Write

  5. Chage Log On as properties for MySQL Service to Mysql_user.
    MySQL Service > Properties > Log On > This account > Select Mysql_user

  6. Start MySQL Service

Related Topic