From tleffler@u.washington.edu Mon Sep 17 09:58:49 2001 Received: from mxu102.u.washington.edu (mxu102.u.washington.edu [140.142.32.15]) by lists.u.washington.edu (8.11.2+UW01.01/8.11.2+UW01.04) with ESMTP id f8HGwl076230 for ; Mon, 17 Sep 2001 09:58:47 -0700 Received: from mxu2.u.washington.edu (mxu2.u.washington.edu [140.142.32.9]) by mxu102.u.washington.edu (8.11.6+UW01.08/8.11.6+UW01.08) with SMTP id f8HGwkE28981 for ; Mon, 17 Sep 2001 09:58:46 -0700 Received: FROM mxout1.cac.washington.edu BY mxu2.u.washington.edu ; Mon Sep 17 09:58:46 2001 -0700 Received: from mailhost1.u.washington.edu (mailhost1.u.washington.edu [140.142.32.2]) by mxout1.cac.washington.edu (8.11.6+UW01.08/8.11.6+UW01.08) with ESMTP id f8HGwje29275 for ; Mon, 17 Sep 2001 09:58:45 -0700 Received: from u.washington.edu (D-128-208-49-96.dhcp.washington.edu [128.208.49.96]) by mailhost1.u.washington.edu (8.11.6+UW01.08/8.11.6+UW01.08) with ESMTP id f8HGwjP08015 for ; Mon, 17 Sep 2001 09:58:45 -0700 Sender: tleffler@u.washington.edu Message-ID: <3BA62BC4.11FE1991@u.washington.edu> Date: Mon, 17 Sep 2001 09:58:44 -0700 From: Trevor Leffler X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.5 i686) X-Accept-Language: en MIME-Version: 1.0 To: linux@u.washington.edu Subject: Re: mySQL on dante... References: <03f901c13db7$d53a1eb0$a83cd080@jack> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jay Ryu, This problem could be a couple of things. First, your MySQL server may not even be running. Use the 'ps' command to find out. (Don't know how to use ps? Type 'man ps' at the prompt.) Also, did you follow the advice and look to see whether that mysql.sock file (actually, a socket) really exists? You should. If it doesn't, your server isn't started. If it does, see below. Second, you might be on a different dante than what you started your server on. There are something like 48 dantes. If you started the server on dante26, you can't access it from dante16 or any others for that matter. I would suggest that you're either very aware of which dante you're on, or use vergil, since there is only one of them at the moment. Next, Dejan mentioned something about permissions. Once you get your server running, you need to make sure that others can't access it with admin privileges, and that your programs can access the tables that they need. You can read all about this in Chapter 6 of the documentation at www.mysql.com. In fact, read this BEFORE you start any servers. Finally, I should mention that the binaries for the latest MySQL release are not compatible with UW's UA servers (dante, homer, etc). They are compiled for a different version of AIX (IBM's UNIX OS). So, you can either use the binaries for MySQL 3.22.XX or try compiling 3.23.XX on your own. And remember, you can't compile on dante or homer, use vergil or ovid. Thanks, -- Trevor Leffler, Software Developer PETTT / Ed-Tech Development Group University of Washington (206) 616-3406 / OUGL 230, Box 353080 JAY HYUN RYU wrote: > > Dear All > > After following the direction at > http://depts.washington.edu/mysql/mysql.html, > I got an error message below, > > dante13% ./bin/mysqladmin -u root '' > ./bin/mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket '/mysql.sock' (2)' > Check that mysqld is running and that the socket: '/mysql.sock' exists! > dante13% > > Even though I tried to several ways, I couldn't make it. > I greatly appreciate your comment. > > Jay Ryu > > Dept. of Civil Engineering. > 206)616-1775 .