I had the permissions set for /var/mysql set to mysql:mysql, however the 
directories underneath it were set up as root:wheel (because I had 
installed as root, I suppose).

I fixed it with
chown -R mysql /var/mysql
chgroup -R mysql /var/mysql

It now seems to work just fine. Thanks for the reminder.

Luke Mewburn wrote:

>On Tue, Jan 28, 2003 at 03:37:26PM -0500, Brian Rose wrote:
>  | I am trying to get the MySQL database up and running and I am having 
>  | some difficulties.
>  | 
>  | I installed from source with the following...
>  | 
>  | cd /usr/pkgsrc/databases/mysql-server
>  | make
>  | make install
>  | cd /usr/pkgsrc/databases/mysql-client
>  | make
>  | make install
>  | 
>  | I then try to start the server with the following command...
>  | cd /usr/pkg/share/mysql
>  | ./mysql.server start
>  | 
>  | The server dies almost immediately and the reported error is...
>  | 030122 20:11:08  mysqld started
>  | 030122 20:11:08  /usr/pkg/libexec/mysqld: Can't find file: 
>  | './mysql/host.frm' (errno: 13)
>  | 030122 20:11:08  mysqld ended
>  | 
>  | I look for the file and it is in /var/mysql/mysql/host.frm
>  | 
>  | I try starting the server from /var/mysql and I still get the error.
>  | 
>  | I've been looking at halp pages, but it is mostly for Linux systems and 
>  | they seem to put their mysql stuff in /usr/local instead of /var/mysql, 
>  | so I'm not sure where to start looking for trouble.
>
>What are the permissions on /var/mysql ?  That heirarchy should be
>owned by mysql:mysql (or more accurately, ${MYSQL_USER}:${MYSQL_GROUP})
>
>Were there any messages during the installation of mysql asking you to
>ensure that the permissions are set correctly and the users exist?
>
>
>Luke.
>
>  
>