I have added secure-file-priv = "" to my nano /etc/my.cnf file for mysql and now I’m not able to remove it.When I remove that line and try to save it, it’s asking me to write to a file and the changes are not saved
I tried to uninstall and install mySQL but due to this the server is not able to start.
Error Messages:
my_print_defaults: [ERROR] Found option without preceding group in config file /etc/my.cnf at line 1.
my_print_defaults: [ERROR] Fatal error in defaults handling. Program aborted!
Starting MySQL
.my_print_defaults: [ERROR] Found option without preceding group in config file /etc/my.cnf at line 1.
my_print_defaults: [ERROR] Fatal error in defaults handling. Program aborted!
my_print_defaults: [ERROR] Found option without preceding group in config file /etc/my.cnf at line 1.
my_print_defaults: [ERROR] Fatal error in defaults handling. Program aborted!
Is there any way I can fix this error, I tried a lot but couldn’t find any solution
>Solution :
"errors when saving" are often linked to access rights issues.
-
run
ls -l /etc/my.cnfto confirm that this file is owned byroot. -
in the vast majority of cases, system wide configuration files are owned by
root. To edit arootfile, you should do it with root privileges, e.g :
sudo nano /etc/my.cnf
(that’s probably how you were able to add the config parameter in the first place)