From owner-freebsd-database@FreeBSD.ORG  Sun Feb  8 04:13:27 2004
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id D1B4D16A4CF
	for <freebsd-database@freebsd.org>;
	Sun,  8 Feb 2004 04:13:27 -0800 (PST)
Received: from anubis.medic.chalmers.se (anubis.medic.chalmers.se
	[129.16.30.218])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9F16043D1D
	for <freebsd-database@freebsd.org>;
	Sun,  8 Feb 2004 04:13:27 -0800 (PST)
	(envelope-from moro@medic.chalmers.se)
Received: from moro.dtek.chalmers.se (moro.dtek.chalmers.se [129.16.30.44])
	by anubis.medic.chalmers.se (Postfix) with ESMTP id DE78443BEB3
	for <freebsd-database@freebsd.org>;
	Sun,  8 Feb 2004 13:13:25 +0100 (MET)
Date: Sun, 8 Feb 2004 13:13:25 +0100 (MET)
From: Stefan Moro <moro@medic.chalmers.se>
X-X-Sender: moro@moro.dtek.chalmers.se
To: freebsd-database@freebsd.org
Message-ID: <Pine.GSO.4.58.0402081256110.20804@moro.dtek.chalmers.se>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Subject: mysql40 and FBSD 4.9
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 08 Feb 2004 12:13:28 -0000

Hi,

First of all I just want to say that I've never used mysql before so there
might not be any problem at all, except me not understanding how to do =)

I'm trying to setup mysql40. I installed it from the ports via the
mysql40-server port. The installation went just fine. Afetr the
installation I was trying to set the mysql root-users password with
mysqladmin -u root password 'new-password'

when i tried that I got the following message:

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

The server should be up and running because the command mysqladmin version
gave the following output:

mysqladmin  Ver 8.40 Distrib 4.0.17, for portbld-freebsd4.9 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          4.0.17
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /tmp/mysql.sock
Uptime:                 2 days 15 hours 4 min 30 sec

Threads: 1  Questions: 8  Slow queries: 0  Opens: 6  Flush tables: 1  Open
tables: 0  Queries per second avg: 0.000


I have read the mysql-manual but have not found any solution for this
problem.

I have also googled for this problem but not found any solution..

uname -a output:

FreeBSD "hostname" 4.9-RELEASE FreeBSD 4.9-RELEASE #1: Thu Nov 20
13:48:26 GMT 2003
root@"hostname":/usr/obj/usr/src/sys/SERVERKERNEL  i386


Do I have to do anything before trying to set the root password or should
this work?

Does anyone know any good mysql tutorial which includes the installation
part of the server?

Any help appreciated
			//Stefan M.