i have a fresh install of freebsd 5.3; no errors and the cvsupdate has been done with no resulting errors.

i switch to and did a "cd /usr/ports/databases/mysql50-server"
i then did "make"
i then did "make install"

i rebooted the machine

i then tried to:
"mysqladmin -u root password mynewpswd"

it returned:

connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket: '/tmp/mysql.sock' (61)
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exist!

Well...
i did a where is on mysqld and it does not exist
and
'/tmp/mysql.sock' does exist.

i then went to mysql docs and could not find a reference to this kind of problem.

any idea?

thanks

Try: mysqld_safe

Maybe mysql is not running, check on how to enable services in the FeeBSD handbook.

when i run mysqld_safe it returns

Starting mysqlddaemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/myhostname.pid
050430 11:36:27 mysqld ended

i also tried
http://www.linuxquestions.org/questi...hreadid=313548

there is an err file in /var/db/mysql stating that mysqld does not have sufficent rights. the entire install has been done through the root id so how can this be possible unless the install process is flawed.

thanks!

OK, I was hoping to avoid the big answer.

You need to create the default database files. The command to do this mysql_install_db.
If you are planning to run mysql as mysql user, which is what you must do, for security reasons,
if the is no mysql user/group do as root
and then log in as mysql like this:
as root do and type the above command (mysql_install_db).

Hope it helps

no go.

groupadd or useradd commands exist (my version is FreeBSD 5.3)

the mysql install did create mysql for groups and users

mysql_install_db did create the database files in folder /var/db/mysql/mysql but mysqld_safe still does not start mysqld same errors as before.

its very confusing.

thanks

did you do mysql_install_db as mysql user as I suggested you?
Because if you have executed this as root the permissions will be root.root and mysql won't be able to access them.
If you did this go and change the ownership of /var/db/mysql/mysql directory and all the files under this directory to mysql.mysql

it says the account is unavailable.

oh well...

going out of town - i'll check back sunday night

thanks everyone!

Day Two.

I'm back in town now.

REVIEWING NOTES......

hmmmmm.......

ok...just for the PURE fun of it i reloaded freebsd and updated the ports

i also created my id and mysql (and associated grps)

SO...i am suppose to install mysql as the msql user and create the DBs in the same manner (IF i want mysql to manage them). right? how about other apps like Apache 2 and PHP for that matter? what id should be used to install them?

thanks

to install mysql should i

1. login as mysql and attempt to install mysql?

or

2. login as mysql and then su to root and do the install?

or

3. login as root and then su to mysql and then do the install?

sockstat -4 if 3306 is in the results then mysql is running if not
did it load on startup no? did you put mysql_enable="YES" in your rc.conf?

Is the mysql installation chrooted on FreeBSD? If so, you need to modify the conf file to put the socket it in the jail. Maybe that helps.

I'm having this EXACT same problem with freebsd 5.4

any pointers would be greatly appreciated, there arent many tutorials on the net, boo