From owner-freebsd-questions@FreeBSD.ORG  Sat May 20 17:08:49 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
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 3863A16A437
	for <freebsd-questions@freebsd.org>;
	Sat, 20 May 2006 17:08:49 +0000 (UTC)
	(envelope-from fbsd@a1poweruser.com)
Received: from mta9.adelphia.net (mta9.adelphia.net [68.168.78.199])
	by mx1.FreeBSD.org (Postfix) with ESMTP id BDDCB43D46
	for <freebsd-questions@freebsd.org>;
	Sat, 20 May 2006 17:08:48 +0000 (GMT)
	(envelope-from fbsd@a1poweruser.com)
Received: from barbish ([70.39.69.56]) by mta9.adelphia.net
	(InterMail vM.6.01.05.02 201-2131-123-102-20050715) with SMTP
	id <20060520170848.UDDH8718.mta9.adelphia.net@barbish>;
	Sat, 20 May 2006 13:08:48 -0400
From: "fbsd" <fbsd@a1poweruser.com>
To: "Peter Michaux" <petermichaux@gmail.com>, <freebsd-questions@freebsd.org>
Date: Sat, 20 May 2006 13:08:42 -0400
Message-ID: <MIEPLLIBMLEEABPDBIEGEEIHHHAA.fbsd@a1poweruser.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0)
In-Reply-To: <3cbaf1c80605200857t4043cc4r519088dad9ccc008@mail.gmail.com>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
Importance: Normal
Cc: 
Subject: RE: installing MySQL with FreeBSD pkg_add
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: fbsd@a1poweruser.com
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 20 May 2006 17:08:50 -0000

The pkg_add -r msql41-server auto installs mysql41-client
as a dependaent so when you ran pkg_add -r mysql41-client
it found it was all ready there just like it should.
This is not an error.

Next you have to do rehash command or reboot box so system
can find those new modules.

Then run
mysql_install_db --user=mysql
from the command line to tell mysql to create its internel control
db.

Then mysql -u root   should work.

-----Original Message-----
From: owner-freebsd-questions@freebsd.org
[mailto:owner-freebsd-questions@freebsd.org]On Behalf Of Peter
Michaux
Sent: Saturday, May 20, 2006 11:58 AM
To: freebsd-questions@freebsd.org
Subject: installing MySQL with FreeBSD pkg_add


Hi,

I am happy to have FreeBSD 6.1-RELEASE and KDE running on my intel
box. I am now trying to install MySQL. I logged in as root and ran
the
following commands

# pkg_add -r msql41-server
 Added group "mysql"
 Added user "mysql"
# pkg_add -r mysql41-client
"mysql-client-4.1.18_1" or its older version already installed
# mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through
socket
'tmp/mysql.sock' (2)


What to do?

Thanks,
Peter
_______________________________________________
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"