From owner-freebsd-questions@FreeBSD.ORG Sun May 15 19:49:34 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 E01F916A4CE for ; Sun, 15 May 2005 19:49:34 +0000 (GMT) Received: from pyro.cenergynetworks.com (pyro.cenergynetworks.com [196.30.191.122]) by mx1.FreeBSD.org (Postfix) with ESMTP id F37BF43DE0 for ; Sun, 15 May 2005 19:49:33 +0000 (GMT) (envelope-from savage@savage.za.org) Received: from localhost ([127.0.0.1] helo=pyro.cenergynetworks.com) by pyro.cenergynetworks.com with smtp (Exim 4.50) id 1DXP1F-0003As-pk; Sun, 15 May 2005 21:43:21 +0200 Received: from wblv-146-195-156.telkomadsl.co.za ([165.146.195.156] helo=netphobia) by pyro.cenergynetworks.com with esmtpa (Exim 4.50) id 1DXP1C-0003Ao-s7; Sun, 15 May 2005 21:43:19 +0200 Message-ID: <076501c55987$362fb380$0a01a8c0@ops.cenergynetworks.com> From: "Chris Knipe" To: , References: <20050515193710.GA20262@sociostat.org> Date: Sun, 15 May 2005 21:49:28 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-PMX-Version: 4.7.1.128075, Antispam-Engine: 2.0.3.0, Antispam-Data: 2005.3.10.17 Subject: Re: can't connect to mysql X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Chris Knipe List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 15 May 2005 19:49:35 -0000 vi /etc/rc.conf mysql_enable="YES" :wq /usr/local/etc/rc.d/mysql-server.sh start mysql and you should be fine. read what the port installation says the next time you install a port ;-) -- Chris. I love deadlines. I especially love the whooshing sound they make as they fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy' ----- Original Message ----- From: "Eric Cheney" To: Sent: Sunday, May 15, 2005 9:37 PM Subject: can't connect to mysql > 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 > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org"