Mysql permissions

[John E. Goetz]

Is there a reason that the default permissions on /opt/mysql/src & /var/opt/mysql/var are world writable?

Also is there a process, command or config file for mysql to verify if a system is using it?

[Steven E. Protter · Accepted solution]

Shalom John,

UNIX95=1
ps -C mysql

That is not a standard location for mysql files. It may be an alternate location for data, since the default location is often in /var/lib/mysql

Check the dates on the files and the directory with ll and ll -d

That will let you know when they were last used.

Check /etc/my.cnf
It will tell you the current locations of the files.

The only reason those things should be world writable is if remote machines are doing mysql access. The more common model limits access to localhost and lets a web server or client running on the local server have access, thus permitting more strict permissions.

SEP