the MySQL service on local computer started and then stopped
Also remember to give NETWORK SERVICE permission to the folder:
- Right-click
Data
folder - Select
Properties
- Select
Security
tab - Click
Advanced
- Click
Change Permissions...
- Click
Add...
- Type
NETWORK SERVICE
- Click
Check Names
- Click
OK
- Select
Full Control
- Click
OK
– four times - Start MySQL service
After installing it by mysqld --install
. Try this mysqld --initialize
. We got the same problem but it's now working.
If using version 8 and you edit the my.ini I found that Notepad is putting 3 hex characters at the beginning of the my.ini file. EF BB BF. Deleting the 3 characters from the beginning of the file in a hex editor fixes the problem.
In version 8 they are accidentally putting Unicode characters in the ini file. This is causing Notepad to save the file with Byte order mark characters.
The following line in the file is the culprit "The line # range from 1 to 2^32 − 1. “Unique” means that each ID must be different." has 3 Unicode characters. This is causing notepad to append the byte order mark to the text file.