Every now and again, when installing or upgrading MySQL on Windows, mysqld will not start, and it’s not due to any changes in the config file, using some old config option, permissions, something changed/removed, or anything else. It just simply fails, when you know it should work.
If you’re lucky, you’ll at least see the “Can’t create IP socket: No such file or directory” error in the error log.
However, the above error is generated when you invoke mysqld from the command line, and not via the service.
So if you’re not seeing any error on the console, or in the error log, when starting mysql via the service, then try it from the command line, so you can perhaps get more information in the error log.
The “Can’t create IP socket: No such file or directory” error is not very specific, nor is it helpful in determining the problem (especially since this in on Windows).
However, I’ve …
[Read more]