freebsd stable - Nov 2004 - Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)

Hi

I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried
to run mysqld_safe to add a root password but i can't seem to run the
safe command because it shuts down immediately.

The following error is presented to me:

Fatal error: Can't open privilege tables: File
'/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)

I would like it to load the latin1.conf charset.

I can't find any variable that influences this choice. Probably there
is something not configured or the configuration isn't supported.
Anyway I would like to know how to choose this. I installed the binary
freebsd package which is suppose to be very reliable to a quick start.

Thanks

-- 
Ricardo David Martins
_____________________________________________________________________________________________________

AVISO

Esta mensagem (incluindo quaisquer anexos) pode conter informa??o
confidencial para uso exclusivo do destinat?rio. Se n?o for o
destinat?rio pretendido, n?o dever? usar, distribuir ou copiar este
e-mail. Se recebeu esta mensagem por engano, por favor informe o
emissor e elimine-a imediatamente. Obrigado.

DISCLAIMER

This e-mail (including any attachments) may contain confidential
information for exclusive use of its recipient. If you are not the
intended recipient you must not use, distribute or copy this e-mail.
If you have received this e-mail in error please notify the sender and
delete it immediately. Thank You.

_____________________________________________________________________________________________________

Have you run mysql_install_db yet?

Have you read the freebsd platform notes 
<http://dev.mysql.com/doc/mysql/en/FreeBSD.html> and the post-install 
instructions <http://dev.mysql.com/doc/mysql/en/Post-installation.html>? 
If
not, I'd suggest starting there.

If that doesn't help, write back with some more details, such as:  Is this 
your first attempt to start the server after install?  When you say, "the 
binary freebsd package," which do you mean, one of the two from mysql.com, 
or the packages from freebsd.org?  You mention configuration.  What, if any, 
configuration have you done?  (Mysql ought to start fine with default settings.)

Michael

Ricardo David Martins wrote:
> Hi
> 
> I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried
> to run mysqld_safe to add a root password but i can't seem to run the
> safe command because it shuts down immediately.
> 
> The following error is presented to me:
> 
> Fatal error: Can't open privilege tables: File
> '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
> 
> I would like it to load the latin1.conf charset.
> 
> I can't find any variable that influences this choice. Probably there
> is something not configured or the configuration isn't supported.
> Anyway I would like to know how to choose this. I installed the binary
> freebsd package which is suppose to be very reliable to a quick start.
> 
> Thanks
>