From owner-freebsd-database@FreeBSD.ORG  Fri Mar  2 15:26:54 2007
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id B389516A403
	for <freebsd-database@freebsd.org>;
	Fri,  2 Mar 2007 15:26:54 +0000 (UTC)
	(envelope-from 000.fbsd@quip.cz)
Received: from home.quip.cz (grimm.quip.cz [213.220.192.218])
	by mx1.freebsd.org (Postfix) with ESMTP id 7521A13C4B4
	for <freebsd-database@freebsd.org>;
	Fri,  2 Mar 2007 15:26:54 +0000 (UTC)
	(envelope-from 000.fbsd@quip.cz)
Received: from [192.168.1.2] (qwork.quip.test [192.168.1.2])
	by home.quip.cz (Postfix) with ESMTP id 7EC2162F8;
	Fri,  2 Mar 2007 16:26:52 +0100 (CET)
Message-ID: <45E8423C.506@quip.cz>
Date: Fri, 02 Mar 2007 16:26:52 +0100
From: Miroslav Lachman <000.fbsd@quip.cz>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.7.12) Gecko/20050915
X-Accept-Language: cz, cs, en, en-us
MIME-Version: 1.0
To: "Rajen Jani (BT Yahoo! Broadband)" <x_element108@btinternet.com>
References: <45E82E41.2060007@btinternet.com>
In-Reply-To: <45E82E41.2060007@btinternet.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-database@freebsd.org
Subject: Re: ERROR 1045 (28000): Access denied for user 'zabbix'@'ritm'
 (using, password: YES)
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
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: Fri, 02 Mar 2007 15:26:54 -0000

Rajen Jani (BT Yahoo! Broadband) wrote:

> Hello people,
> 
>                Thanks for helping me out last time. I am still having
> the above problem. I did the following prior:
> 
> shell>> mysql
> 
> mysql> GRANT ALL PRIVILEGES ON zabbix TO .*  'zabbix'@'ritm' IDENTIFIED
> BY 'password';

You have wrong syntax of GRANT command. Right is:

mysql> GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@ritm IDENTIFIED
BY 'password';

where first "zabbix" is database name and asterisk wildcard means "all 
tables in this database", second "zabbix" is username and "ritm" is 
hostname (FQDN or IP adrress) of the machine from which the user zabbix 
will connect from. If database server and zabbix user is on the same 
machine, it should be localhost.

Miroslav Lachman