Subject: /var/mysql/ permissions
To: None <tech-pkg@netbsd.org>
From: Dan <kasper37@netzero.com>
List: tech-pkg
Date: 03/26/2003 23:39:45
After a simple make install in mysql-server I did this:

--------------------------------------
bash-2.05b# /etc/rc.d/mysqld start
Starting mysqld.
bash-2.05b# mysqldump -A >backupdump.sql
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61) when trying to connect
bash-2.05b# cd /var/mysql/
bash-2.05b# cat test2.testsystem.com.err
033826 15:38:13  Starting mysqld daemon with databases from /var/mysql
033826 15:38:13  mysqld started
030326 15:38:13  /usr/pkg/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
033826 15:38:13  mysqld ended
bash-2.05b# chown -R mysql mysql/
bash-2.05b# chown -R mysql test/
bash-2.05b# /etc/rc.d/mysqld start
Starting mysqld.
bash-2.05b# mysqldump -A >backupdump.sql
bash-2.05b#
--------------------------------------

Am I doing something wrong or are those directories not chowned to the correct
user on install?

Dan