MySQL.sock permissions

DutchDaemon said:
Just to make sure:

[cmd=]ls -ld /var[/cmd] should give
Code:
drwxr-xr-x
[cmd=]ls -ld /var/tmp[/cmd] should give
Code:
drwxrwxrwt

hq# ls -ld /var
Code:
drwxr-xr-t  31 root  wheel  1024 Dec  1 22:21 /var
hq# ls -ld /var/tmp/
Code:
drwxrwxrwt  4 mysql  mysql  1024 Dec  3 22:22 /var/tmp/

It is all good, mysql running.
Thank you very much.
 
No, it's not all good. Just read what you post. There should not be a sticky bit (t) on the /var/ directory. Run:

[cmd=]chmod 0755 /var[/cmd].

Moreover: /var/tmp/ should not be owned by user/group mysql.

[cmd=]chown root:wheel /var/tmp[/cmd]
 
DutchDaemon said:
No, it's not all good. Just read what you post. There should not be a sticky bit (t) on the /var/ directory. Run:

[cmd=]chmod 0755 /var[/cmd].

Moreover: /var/tmp/ should not be owned by user/group mysql.

[cmd=]chown root:wheel /var/tmp[/cmd]

Ok, thanks! ;-)


[cmd=]hq# chmod 0755 /var[/cmd]
[cmd=]hq# chown root:wheel /var/tmp[/cmd]
[cmd=]hq# ./mysql-server stop[/cmd]
Code:
Stopping mysql.
Waiting for PIDS: 46541.
[cmd=]hq# ./mysql-server start[/cmd]
Code:
Starting mysql.
[cmd=]hq# ps axww | grep mysql[/cmd]
Code:
46609  ??  Ss     0:00.11 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-
file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-
file=/var/db/mysql/hq.hostname.pid
46753  ??  SL     0:00.93 /usr/local/libexec/mysqld --defaults-extra-
file=/var/db/mysql/my.cnf --basedir=/usr/local --datadir=/var/db/mysql --plugin-
dir=/usr/local/lib/mysql/plugin --log-error=/var/db/mysql/hq.hostname.err --pid-
file=/var/db/mysql/hq.hostname.pid
 
Back
Top