From owner-freebsd-questions@FreeBSD.ORG Fri Sep 9 09:08:26 2005 Return-Path: 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 6AE7E16A41F for ; Fri, 9 Sep 2005 09:08:26 +0000 (GMT) (envelope-from freebsduser@comcast.net) Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [63.240.76.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 14AFF43D48 for ; Fri, 9 Sep 2005 09:08:25 +0000 (GMT) (envelope-from freebsduser@comcast.net) Received: from opteron (c-67-171-212-242.hsd1.or.comcast.net[67.171.212.242]) by comcast.net (sccrmhc11) with SMTP id <2005090909082101100bbin5e>; Fri, 9 Sep 2005 09:08:25 +0000 Message-ID: <000e01c5b51e$0984ed80$0c64a8c0@opteron> From: "K Anderson" To: "Chezangla, Engineer, DrukNet" , References: Date: Fri, 9 Sep 2005 02:08:21 -0700 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Response Cc: Subject: Re: hi list X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 09 Sep 2005 09:08:26 -0000 ----- Original Message ----- From: "Chezangla, Engineer, DrukNet" To: Sent: Thursday, September 08, 2005 7:23 PM Subject: hi list > Can anyone give me the detail steps for installing and configuring mysql > server on freebsd......... > > I have installed mysql from ports but some how could not start the mysql > daemon........installation might be wrong .....so can anyone who did the > same give me some suggestions plez...... > > FreeBSD5.1 > mysql40-server cd /usr/ports/databases/mysql40-server make install clean {Wait} At some point the process may tell you to edit your rc.conf to add the item (I'm using mysql41-server so it might be different): mysql_enable="Yes" Then you can try starting it up with: /usr/local/etc/rc.d/mysql-server.sh start The startup script might notice something is missing and go in and create the databases needed. If all goes well you should be able to do: mysql One of three things may happen: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) That means mysql didn't startup - OR - ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) That means you didn't tell mysql (the command from -- If all goes well you should... -- section) to prompt for a password so you can get in. If you don't know the password for the root account then you can head over to the mysql web site and find out how to start mysql daemon without checking priviliges. Also review user accounts and how they work. No errors and you are in mysql and ready to go. It's not much, but hope it helps. Mr. Anderson ~Sir, put the mouse down and step away from the computer~