From owner-freebsd-questions Mon Dec 9 5: 5: 3 2002 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 8E41837B401 for ; Mon, 9 Dec 2002 05:05:01 -0800 (PST) Received: from mout2.freenet.de (mout2.freenet.de [194.97.50.155]) by mx1.FreeBSD.org (Postfix) with ESMTP id CB3A643EB2 for ; Mon, 9 Dec 2002 05:04:59 -0800 (PST) (envelope-from michael.radzewitz@freenet-ag.de) Received: from [194.97.50.138] (helo=mx0.freenet.de) by mout2.freenet.de with asmtp (Exim 4.10) id 18LNaY-0000vt-00; Mon, 09 Dec 2002 14:04:46 +0100 Received: from staffbox.freenet-ag.de ([62.104.227.26]) by mx0.freenet.de with esmtp (Exim 4.10 #4) id 18LNaY-0003WB-00; Mon, 09 Dec 2002 14:04:46 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: AW: Mysql problem Date: Mon, 9 Dec 2002 14:04:40 +0100 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Mysql problem Thread-Index: AcKff38b+hQjn88pRzecCg4yzWbkJAAAXV5Q From: "Michael Radzewitz" To: "Wayne Swart" , "FreeBSD Mailing list" Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG It looks like your mysql-server did'nt start up proberly. After running the start-script check if the server is up: ps aux | grep mysqld Also have a look at the logfiles. You will find the error log in the directory where your databases live: normally this is: /var/db/mysql/hostname.err. Where hostname is the name of your system. When the server is not running, check the filepermissions and owner. The directory above must be owned by the same user under which the mysql-daemon is running. When the server is up. Find the socket file and pass it as an argument to the mysql-client. mysql --host=3Dlocalhost --socket=3D/some/dir/mysql.sock After the first startup there is no password for the user root. You should change this. michael > -----Urspr=FCngliche Nachricht----- > Von: Wayne Swart [mailto:fixx@fixx.co.za] > Gesendet: Montag, 9. Dezember 2002 13:37 > An: FreeBSD Mailing list > Betreff: Mysql problem >=20 >=20 > Good day ppl >=20 > I have installed mysql323-server from the ports without any=20 > command line > arguments on freebsd 4.7. >=20 > i start the sql server by running /usr/local/etc/rc.d/mysqld.sh start >=20 > the server seems to start fine, but as soon as i try to=20 > connect to it, it > gives the following error: >=20 > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) >=20 > the file /tmp/mysql.sock does not exsist though > can someone please help me with this? >=20 > thanks > Wayne >=20 > In a world with no boundaries, who needs gates? >=20 > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message >=20 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message