From owner-freebsd-questions Thu Apr 18 9:12:24 2002 Delivered-To: freebsd-questions@freebsd.org Received: from smtp014.mail.yahoo.com (smtp014.mail.yahoo.com [216.136.173.58]) by hub.freebsd.org (Postfix) with SMTP id B21F837B421 for ; Thu, 18 Apr 2002 09:11:42 -0700 (PDT) Received: from 12-220-244-231.client.insightbb.com (HELO Kaiser) (donniejones18@12.220.244.231 with login) by smtp.mail.vip.sc5.yahoo.com with SMTP; 18 Apr 2002 16:11:42 -0000 Date: Thu, 18 Apr 2002 12:11:48 -0400 From: Donnie Jones 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> X-Mailer: Sylpheed version 0.6.6 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG 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" 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