after the weekend i reviewed my previous posting concerning mysql 5 and apparently I AM MISSING THE BOAT!
i believe that you guys are giving the assistance needed but somewhere along the way the message is not being read correctly by this noob sitting at this keyboard.
here is what i have.
a freshly installed FreeBSD 5.3 and the ports have been installed and updated
during the install phase of the OS i added two other groups (myself and mysql) and two additional user ids (myself and mysql)
here is what i have tried
1. installed as mysql (died after the first screen)
2. installed as root (made it through the install process)
however, root owns everything and mysql_install_db is not sucessful
so, "su root" was issued and mysql_install_db tried again still no go
i also tried mysqld_safe and that failed too
the install appears correct when root does it. no errors that i can see except it will not create the DBs, run mysqld_safe.
when this was attempted as user mysql it fails saying that it does not have sufficient rights so i gathered that doing "su root" to do the install is a bad thing as well as installing as root.
what are the correct steps before i step off the cliff again?
your help is very apprciated BTW