> Initialised it how?
Using mysqld --initialize --datadir
>
https://dev.mysql.com/doc/refman/8.0/en/windows-create-option-file.html
That just says to create a new file using a text editor. I'm specifically looking to get the default option file, not an empty file.
Oddly enough this page:
https://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
states that no default option file is created during data directory initialization on a non-Windows platform, which suggests that since I'm using Windows, one should've been created, except it wasn't. I also haven't been able to find a my.ini or my-default.ini anywhere on my computer. Hence why I need to find out how to create it.
> WB needs a MySQL server running, doesn't need a
> service.
>
>
https://dev.mysql.com/doc/refman/8.0/en/windows-start-service.html
> describes how to configure a Windows MySQL
> service.
True, but it makes it easier since I won't have to run mysqld with all the necessary options every time I need to access a server. And like I said, I already created a service for it, so the link on how to do it is obviously unnecessary. Only problem is that it's not added in Workbench despite being found, and that I obviously couldn't refer to --defaults-file since I don't have one as of yet.