From owner-freebsd-questions@FreeBSD.ORG Sun May 15 19:39:40 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7913916A4CE for ; Sun, 15 May 2005 19:39:40 +0000 (GMT) Received: from sociostat.org (echeney.adsl.spfdma.crocker.net [159.250.21.104]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3DC5C43DB9 for ; Sun, 15 May 2005 19:39:40 +0000 (GMT) (envelope-from eric@sociostat.org) Received: from eric by sociostat.org with local (Exim 3.36 #1 (Debian)) id 1DXOvH-0005J8-00 for ; Sun, 15 May 2005 15:37:11 -0400 Date: Sun, 15 May 2005 15:37:11 -0400 From: Eric Cheney To: freebsd-questions@freebsd.org Message-ID: <20050515193710.GA20262@sociostat.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.9i Sender: Eric Cheney Subject: can't connect to mysql X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: cheney@soc.umass.edu List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 15 May 2005 19:39:40 -0000 Hello. I'm trying to get MySQL4.0 working. I've installed it using /stand/systinstall (as well as ports method on another attempt). I got a report from sysinstall that MySQL was installed. That's both the client and the server (it caught the dependencies.) But here's the problem: I can't connect to the database. Here's the error I get.... ****begin error message****** max# mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ****end error message****** I did the above leaving the password blank because I haven't set up a password for root on MySQL yet. Which brings up another problem. I've tried the below and get the stated message..... ****begin error message****** max# mysqladmin -u root password 'newpassword' mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! max# ****end error message****** Well sure enough, /tmp/mysql.sock does not exist. And a "ps waux | grep msyql" leaves me to believe that mysql is not running. So then I did this, as root .... max# /usr/local/etc/rc.d/mysql-server.sh start And still mysql is not running, and I get the same problems as stated above. Any ideas about what I'm doing wrong? Thank you. -- cheney@soc.umass.edu