Subject: Re: MySQL installation
To: Brian Rose <saider@gate.net>
From: Luke Mewburn <lukem@netbsd.org>
List: netbsd-users
Date: 01/29/2003 11:58:34
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.