From owner-freebsd-questions@FreeBSD.ORG Thu Dec 9 22:18:39 2004 Return-Path: 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 C1F0816A4CE for ; Thu, 9 Dec 2004 22:18:39 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.205]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4DABD43D2F for ; Thu, 9 Dec 2004 22:18:39 +0000 (GMT) (envelope-from john.destefano@gmail.com) Received: by rproxy.gmail.com with SMTP id z35so365663rne for ; Thu, 09 Dec 2004 14:18:38 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=MTXPpn8el/hm+RzPp52Ah0UXQJUpQ9LDjgtaUQGCjM9i2fD9YHPRmakb4OGsnuqCs177HRcvDycC5uO50W6PMw/zkr5qxhrfCKIzUn1GtYTg3tIrexCARd2kHLVZ9+aUBw9DcFP5FOzYFRCwbVYe6jyopD3VxjNR0d+87K8BvEI= Received: by 10.38.104.3 with SMTP id b3mr742948rnc; Thu, 09 Dec 2004 14:18:38 -0800 (PST) Received: by 10.38.99.32 with HTTP; Thu, 9 Dec 2004 14:18:38 -0800 (PST) Message-ID: Date: Thu, 9 Dec 2004 17:18:38 -0500 From: John DeStefano To: freebsd-questions@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Subject: mysql connect problems X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: John DeStefano List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 09 Dec 2004 22:18:39 -0000 I wanted to give a try at enhancing my knowledge and improving my Web server/sites by adding blog (Mobile Type) and wiki (MediaWIki) applications. If you've ever tried to install/configure either of these two apps on FreeBSD, perhaps you already know the frustration I've met over the past 24 hours: multiple dependencies, modules, untold configurations, etc., especially in the case of Mobile Type. In fact, if you've got a better suggestion in either case, I wouldn't be adverse to scrapping one or both packages and starting from scratch with something else. Anyway, after much Googling and tinkering, I made some advances but seem to have come up against a problem in the vein of a very common theme: MySQL connections in FreeBSD. Not that I'm blaming the operating system; I'm quite aware this is more an 'operator error' than anything else. Just appears that a lot of FBSD users just starting out with MySQL or MySQL-dependent packages run into this. Neither of the two above-mentioned applications can connect to my MySQL services (access denied in both cases). I have created databases and appropriate users for each, and I've tried to grant the appropriate permissions. All that seemed to work, but I still can't connect properly. At a prompt, if I try to connect to mysql using the '-p' option like this: # mysql -u root -p ... I can connect. But if I try to connect without '-p' like this: # mysql -u root ... I get an error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root'@'localhost' (Using password: NO)' >From what I can gather, this has to do with setting passwords for different aliases or incarnations of the host for a single user (root). I've tried every solution I've found for adding additional connection settings for root (including more than one method for changing the root password). When I log into mysql as root, use the mysql database, and run 'select user, password, host from user;' I see multiple entries for root for different 'host' values ('localhost', the actual host name, and '%'). I'd appreciate any help at all with this. Thanks very much. ~John