From owner-freebsd-database@FreeBSD.ORG Mon Mar 27 06:38:21 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 59EC016A41F for ; Mon, 27 Mar 2006 06:38:21 +0000 (UTC) (envelope-from glenn@mail.more.net) Received: from libby.lpmo.org (libby.lpmo.org [216.106.2.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0E9D243D45 for ; Mon, 27 Mar 2006 06:38:20 +0000 (GMT) (envelope-from glenn@mail.more.net) Received: from gkar.earthdome.org (galen.earthdome.org [206.152.117.245]) by libby.lpmo.org (Postfix) with ESMTP id 8A9632841B for ; Mon, 27 Mar 2006 00:37:23 -0600 (CST) Received: by gkar.earthdome.org (Postfix, from userid 503) id 7A47F56DEA9; Mon, 27 Mar 2006 00:37:21 -0600 (CST) Date: Mon, 27 Mar 2006 00:37:21 -0600 From: Glenn Nielsen To: freebsd-database@freebsd.org Message-ID: <20060327063721.GA17259@gkar.earthdome.org> References: <4b4e1af10603262213g11b0943g1455e9ddb2a4e095@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4b4e1af10603262213g11b0943g1455e9ddb2a4e095@mail.gmail.com> User-Agent: Mutt/1.4.2.1i Subject: Re: mysql can't connect 2002 & socket error X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 27 Mar 2006 06:38:21 -0000 On Sun, Mar 26, 2006 at 10:13:22PM -0800, peptide one wrote: > Hello all, > > I've been scanning these mail lists for a solution and have tried many > things, but am still not able to start the MySQL 5.0 database on my FreeBSD > 5.4 server. I've been working on this for two days and have never had so > many problems getting a database to start. > > The first thing I did after installation was copy the /support-files/my- > medium.cnf > to > /etc/my.cnf > and enter the appropriate information. You don't need a my.cnf file to start mysql. Only if you need to override the defaults. Then you would put it in /var/db/mysql/my.cnf. > I also created a "dummy" /tmp/mysql.sock file and configured permissions. > I try starting the server as user "mysql" and it fails. Trying to su or > login as mysql fails with a 'miscofiguration' error. mysql creates this unix socket when it starts up. > All this has happened after I've deinstalled and cleaned two previous > installations. > > This is getting to be much more work than it should be. > > Can anyone help? It would certainly be appreciated. I can think of two simple things which would prevent the mysql db from starting. After a new install of mysql you must run mysql_install_db to setup the default database tables. Second you have to make sure you have the appropriate entries in your /etc/rc.conf file which tells FreeBSD whether and how it should start mysql. See the /usr/local/etc/rc.d/mysql-server.sh start script. The start script won't start mysql unless /etc/rc.conf is configured for it. This is based on my experience with MySQL 4.1, I would expect it would be the same for MySQL 5. Regards, Glenn ---------------------------------------------------------------------- Glenn Nielsen glenn@more.net | /* Spelin donut madder | MOREnet System Programming | * if iz ina coment. | Missouri Research and Education Network | */ | ----------------------------------------------------------------------