Date: Thu, 18 Apr 2002 12:11:48 -0400 From: Donnie Jones <donniejones18@yahoo.com> To: freebsd-questions@freebsd.org Subject: Re: mysql.sock error, when trying to safe_mysqld as non-root admin Message-ID: <20020418121148.2097b9c8.donniejones18@yahoo.com>
next in thread | raw e-mail | index | archive | help
I ran into this exact same problem recently when I upgraded my php version for my linux webserver. It seems that instead of creating the mysql.sock file in /tmp that the mysql was creating it in /var/run/mysql : # ls -l /tmp/mysql.sock lrwxrwxrwx 1 root root 25 Apr 16 00:47 /tmp/mysql.sock -> /var/run/mysql/mysql.sock= To remedy this problem I created a symlink from /var/run/mysql.sock to /tmp/mysql.sock: # ln -s /var/run/mysql.sock /tmp/mysql.sock That command should do it for you. I am not sure if there is any security issues with this, but it fixed the problem for me, so I was happy. :-) Good luck, --Donnie Jones http://www.darthik.com On Thu, 18 Apr 2002 05:29:00 +0000 "Seamus Roche" <seamusjr@hotmail.com> wrote: > I have successfully installed MySQL from ports for FreeBSD 4.5 Stable. The > next step I took was to set up my non-root MySQL admin user who I created a > new user specifically for the task called: mysqladm. So I went and enabled > mysqladm to write and execute from /tmp/ and I chowned the mysql-server > files from root to mysqladm with mysql group, but I keep getting this same > error if I try to run safe_mysql from mysqladm user: > > bash-2.05$ safe_mysqld > Starting mysqld daemon with databases from /var/db/mysql > rm: /tmp/mysql.sock: Operation not permitted > 020418 00:23:28 mysqld ended > > Cheers, > Seamus > > Thanks to Donnie Jones and Jesper Wallin for the help with the hostname > problem while installing MySQL. > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020418121148.2097b9c8.donniejones18>