From owner-freebsd-questions@FreeBSD.ORG  Thu Aug 18 10:52:44 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
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 681D216A41F
	for <freebsd-questions@freebsd.org>;
	Thu, 18 Aug 2005 10:52:44 +0000 (GMT)
	(envelope-from vladone@spaingsm.com)
Received: from mail.spaingsm.com (llwb135.servidoresdns.net [217.76.137.82])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 0AB0843D45
	for <freebsd-questions@freebsd.org>;
	Thu, 18 Aug 2005 10:52:43 +0000 (GMT)
	(envelope-from vladone@spaingsm.com)
Received: from SERVEREL (unknown [85.120.13.254])
	(using TLSv1 with cipher AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.spaingsm.com (Postfix) with ESMTP id 2C02024C6C3
	for <freebsd-questions@freebsd.org>;
	Thu, 18 Aug 2005 12:38:43 +0200 (CEST)
Date: Thu, 18 Aug 2005 13:52:36 +0300
From: vladone <vladone@spaingsm.com>
X-Mailer: The Bat! (v3.0.1.33) Professional
X-Priority: 3 (Normal)
Message-ID: <571953085.20050818135236@spaingsm.com>
To: freebsd-questions@freebsd.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Subject: i can't connect remote to my mysql server
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: vladone <vladone@spaingsm.com>
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 18 Aug 2005 10:52:44 -0000

I have instaled mysql server succcesfull and started. I set root
password, i can login to my server from console but i can't login
remote (i use Mysql Control Center for win, for quickly management).
I receive this error: "host 192.168.100.4 is not allowed to connect to
this Mysql server"
I dont know why, server is up and running.

#ps aux|grep mysql
mysql 11706  0.0  0.4  1660  1060  p0  I     1:37PM   0:00.01 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --da
mysql 11726  0.0  9.7 57136 25064  p0  S     1:37PM   0:00.81 /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local --dat

#sockstat -4
USER     COMMAND    PID   FD PROTO  LOCAL ADDRESS         FOREIGN ADDRESS
mysql    mysqld     11726 3  tcp4   *:3306                *:*

Another question is about config files. I dont know where is config
file for mysql on freebsd. In linux exist mysql.cnf but here ... i
dont see anything.