[13 Mar 2013 7:59] david trillo
I write on the right my.ini file.
The service is created like this:
"C:\Archivos de programa\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\Documents and Settings\All Users\Datos de programa\MySQL\MySQL Server 5.6\my.ini" MySQL56
And THIS is the file iI'm changing!
Finally, i got WHY was this error happening!
When creating the service, It used a user like NTblablabla, instead of a local user.
After changing this, everything was OK!
i'm happy to find the solution. It wasn't the datadir, but how the service was created (the user)!
i hope this can be useful to other users!
[13 Mar 2013 21:28] Wichen Moormann
Thanks to david trillo. We solved the problem also.
It was not a matter of correct my.ini.
It was a matter of user rights of service and data dir.
Let me describe it for Windows Server 2008 R2, which was the last OS i used.
I am always logged in as administrator, but that is not the point.
Important is:
The installer installs the service by default for the user: "network service"
(see properties of the service MySQ56).
If we copy the data dir to a new location (e.g. C: to D:) it has by default
the security rights of the user: "local system"
(see properties of the the new data dir).
---------------------------------------------------------
These different user/rights are the reason for 1067 here.
---------------------------------------------------------
Now we have at least 2 choices:
1. change the service user to: "local system" (as david trillo did)
or
2. add to the data dir security properties the user: "network service",
with all rights.
Both solution work OK when the service is started!
On other OS the problem should be solved analogous.
I hope this is helpfull for others.
Thanks to david trillo again.
1. Open my.ini
2. In [mysqld] section, add the following line:
innodb_force_recovery = 1
3. Save the file and try starting MySQL
4. Remove that line which you just added and Save.
欢迎光临 花江边社区—论坛 (http://archive.huaclub.com/) | Powered by Discuz! 7.2 |