Very Computer

I just installed mysql-3.23.43, apache-1.3.22, and php-4.0.6 all from source
this evening (on freebsd-4.4-r). When I try to run safe_mysqld I get this;

mysqld started
Fatal error: Can't change to run as user 'mysql' ; Please check that the user
exists!
Aboring

I see in the file passwd that the user mysql does not indeed exist.
I have run /bin/mysql_install_db and it appears to run okay. I checked the
online docs but they always refer to running mysql_install_db to set up the
mysql user.
Is it okay to manually add a new user to FreeBSD called mysql? I tried this
but it doesn't work still.
What should I do next?

--
Chip W.

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Quote:> I just installed mysql-3.23.43, apache-1.3.22, and php-4.0.6 all from
> source this evening (on freebsd-4.4-r). When I try to run safe_mysqld I get
> this;

> mysqld started
> Fatal error: Can't change to run as user 'mysql' ; Please check that the
> user exists!
> Aboring

> I see in the file passwd that the user mysql does not indeed exist.
> I have run /bin/mysql_install_db and it appears to run okay. I checked the
> online docs but they always refer to running mysql_install_db to set up the
> mysql user.
> Is it okay to manually add a new user to FreeBSD called mysql? I tried this
> but it doesn't work still.
> What should I do next?

> --
> Chip W.

I know it's not good form to respond to one's own message, but since nobody
else did, and I got it working I thought I'd share this bit.
The source installation absolutely refused to create the user and group
entries necesssary, when running mysql_install_db. It did create the db's.
And I tried to create the group/user manually but that was no good. I tried
re-compiling several times with no luck.
I then decided to try the port, which took a bit longer to install, but in
the end it works fine. I just prefer the way the source install handles the
files/directories better than the port, oh well, I'll live.

--
Chip W.

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php