MySQL Forums
Forum List  »  Newbie

Re: Creating new configuration file for Windows service
Posted by: Michael Pedersen
Date: November 10, 2018 06:06PM

> 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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Creating new configuration file for Windows service
November 10, 2018 06:06PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.