I am new to MySQL on Mac. I am trying to change the configuration variable secure-file-priv, however changes I make to the my.cnf file are not actually being configured.
- Using MySQL Workbench, I created an options file, which is located at /etc/my.cnf.
I made changes to the configuration file in MySQL Workbench (Changing secure-file-priv)
I restarted my instance.
In terminal, I ran the command "cat '/etc/my.cnf'" to verify and confirm that changes I made to the my.cnf file in MySQL workbench were made.
Output:
[mysqld]
..secure-file-priv = 'MY SPECIFIED DIRECTORY'
- in mysql in terminal, I ran the command "SHOW VARIABLES;" to see if the configuration changes had taken effect in mysql. They had not.
Output:
...secure-file-priv = NULL
This confirmed that /etc/my.cnf file was not being read in by mysql
I also tried to specify the path of my configuration file in the MySQL section of system preferences, however this caused the instance to stop, and would not turn back on until I removed the configuration file path.
- I have confirmed that there are no other my.cnf files present on my Mac.
Stuck on what is best to do next to remediate this.