Peter Brawley Wrote:
-------------------------------------------------------
> So for a reason we've not fathomed, the server
> daemon is ignoring /etc/my.cnf.
>
> what is the result of ...
>
> sudo fs_usage | grep my.cnf
When I run
sudo fs_usage | grep my.cnf
I am prompted for my password, I enter it and the terminal application fails to respond with anything...
>
> Does the mysql error log have messages like ...
Please remember I am a Newbie - What is the name of the file and where is it located?
>
> Warning: World-writable config file '/etc/my.cnf'
> is ignored
>
> If so, set its owner to mysql.
If the message is present after I find the error log, not sure how to set the owner to mysql - Newbie
>
> And in System Preferences->Shortcuts->Services,
> what info do you find for the mysql service?
>
Where do I find System Preferences->Shortcuts->Services on a Mac?
> At
>
https://stackoverflow.com/questions/10757169/location-of-my-cnf-file-on-macos
> there are about 30 posts on this topic. Perhaps
> one of those suggestions will hit the mark?
Will check stackoverflow site
>
> At this point, if it's me, I create a my.cnf with
> one line of nonsense in each location listed in
> table 4.2 at
>
https://dev.mysql.com/doc/refman/8.0/en/option-files.html,
> restarting the server each time till I find a
> location where MySQL shows meit's reading my.cnf.
I'm afraid that trying what you described above is out of my "league". All these suggestions for a "newbie" is a bit daunting.
>
> As many users report, MySQL's behaviour on the Mac
> with respect to my.cnf is quixotic at best. If
> you're up to it, consider documenting your rat's
> nest of failures at bugs.mysql.com.
Will consider your last suggestion.
Regards,
Jim P.