Date: Mon, 9 Dec 2002 14:04:40 +0100 From: "Michael Radzewitz" <michael.radzewitz@freenet-ag.de> To: "Wayne Swart" <fixx@fixx.co.za>, "FreeBSD Mailing list" <freebsd-questions@freebsd.org> Subject: AW: Mysql problem Message-ID: <BDC37D9EAC71AE4DB09A7A0D422EEC660653A1@staffbox.freenet-ag.de>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BDC37D9EAC71AE4DB09A7A0D422EEC660653A1>