MySQL Event scheduler:failed to open Table Mysql.event_mysql

In fact, this error literally means that the mysql.event table cannot be opened, which is caused by permission problems. General MySQL also cannot run.

The MySQL service cannot be started on the local computer. Error 1067: Process terminated unexpectedly.

MySQL installation changes the database path to the problem solving method

When installing MySQL on windows, everything is normal after the installation, but for data security considerations, you want to put the database directory under D:\mysql\data, and then modify the My.ini to Datadir= "C:\Documents and Settings\ All Users\Application Data\mysql\mysql Server 5.5\data "to Datadir=" D:/mysql/data.
The MySQL service cannot be restarted after modification.
To view the error record, you are prompted:
[ERROR] Event scheduler:failed to open Table Mysql.event
After finding the data, the following steps can be resolved:
Right-click the MySQL service (some MySQL55, etc.)--click on "Properties"-"Login" tab-"Select the Local System account" radio button-"Apply".

In general, it is not recommended to use the Local system account to run MySQL with mysq low privilege running issues.

First, make sure your my.ini configuration file is fine.

The following cloud-dwelling community small series gives two methods:

Now we have at least 2 choices:
1. Change the service user to: ' Local System ' (as David Trillo did)
Or

Run MySQL with your local System account and don't run with low privileges, which is definitely not good.

2. Add to the Data Dir security properties The User: "Network Service",
With the all rights.

The meaning is to give the data directory permissions, in general, our permissions are inherited, but if the first to do security will have problems.

In fact, the MySQL data directory to the low rights users with all the permissions can be.

Cloud-dwelling Community small series is because of this reason, before all are configured to do security. So later or gradually do a good job.