From jkyllo+lug@echospiral.com Mon Sep 17 11:37:44 2001 Received: from mxu101.u.washington.edu (mxu101.u.washington.edu [140.142.32.14]) by lists.u.washington.edu (8.11.2+UW01.01/8.11.2+UW01.04) with ESMTP id f8HIbd0110912 for ; Mon, 17 Sep 2001 11:37:39 -0700 Received: from mxu1.u.washington.edu (mxu1.u.washington.edu [140.142.32.8]) by mxu101.u.washington.edu (8.11.6+UW01.08/8.11.6+UW01.08) with SMTP id f8HIbd718022 for ; Mon, 17 Sep 2001 11:37:39 -0700 Received: FROM chernobyl.internal.echospiral.com BY mxu1.u.washington.edu ; Mon Sep 17 11:37:38 2001 -0700 Received: from localhost (jkyllo@localhost) by chernobyl.internal.echospiral.com (8.9.3/8.9.3) with ESMTP id LAA27398 for ; Mon, 17 Sep 2001 11:39:54 -0700 Date: Mon, 17 Sep 2001 11:39:53 -0700 (PDT) From: "J. Kyllo" X-X-Sender: To: UW Linux Group Subject: Re: mySQL on dante... In-Reply-To: <3BA62BC4.11FE1991@u.washington.edu> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I haven't used mysql much but I know that you can get to postresql via tcp/ip. If you enable that for mysql then as long as you know what dante it's on you should be able to get to it. Heck, you could get to it from anywhere on campus. -Jeff ________________________________________________ Nach dem Spiel ist vor dem Spiel --Sepp Herberger On Mon, 17 Sep 2001, Trevor Leffler wrote: > 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 > .