MySQL Forums
Forum List  »  Newbie

Re: root user cannot change system variables?
Posted by: Peter Brawley
Date: January 15, 2022 01:05PM

> when I installed MySQL Workbench, there was nothing there.

I believe it's the MySQL installation, not the WB installation, that installs a sample my.cnf. You overwrote when you added the file you found?

But since you have the MySQL server working, you could make your own /etc/mysql/my.cnf, a plain text file that just says ...

[mysqld]
secure_file_priv=""

... and you will need to add the argument ...

--defaults-file=/etc/mysql/my.cnf

... to the MySQL startup command or service definition.

BTW, generic Linux cmd for finding my*.cnf might work on the Mac?

find . -type f -name "*.cnf"



Edited 1 time(s). Last edit at 01/15/2022 01:09PM by Peter Brawley.

Options: ReplyQuote




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.