Error writing my.cnf: Permission denied

Question

I'm attempting to edit my my.cnf file to allow remote access to mysql (by changing the bind-address). However, I'm getting a "Error writing my.cnf: Permission denied" error when I try to save (using pico through SSH).

Running $ lsattr my.cnf returns ---------------- my.cnf

What do I need to do to be able to edit this file?

Thanks!

Who is the owner of `my.cnf`? Root? Then you need to become root also (`su` or `sudo`). Also you need to change the permissions so that mysql user will be able to read it (as root, you can write also to files with these permissions). — Marki555, May 20 '15 at 14:36

score 7 · Answer 1 · answered Nov 27 '18 at 07:01

7

You need to set the file permission as readable and writable.

sudo chmod 644 my.cnf

sudo nano my.cnf

answered Nov 27 '18 at 07:01

sethupathi

81
1
3

score 5 · Answer 2 · answered Jul 11 '15 at 10:46

5

sudo chmod 644 my.cnf

sudo pico my.cnf

answered Jul 11 '15 at 10:46

dev-seahouse

163
1
6

score 3 · Answer 3 · answered May 20 '15 at 14:37

3

Try to edit it as root. Or look for at the file owner and file right with an ls -a.

answered May 20 '15 at 14:37

Leze

739
5
24

Error writing my.cnf: Permission denied

3 Answers3