From owner-freebsd-questions@FreeBSD.ORG Thu Aug 18 11:03:18 2005 Return-Path: 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 B076A16A41F for ; Thu, 18 Aug 2005 11:03:18 +0000 (GMT) (envelope-from albi@scii.nl) Received: from post-25.mail.nl.demon.net (post-25.mail.nl.demon.net [194.159.73.195]) by mx1.FreeBSD.org (Postfix) with ESMTP id 264A343D45 for ; Thu, 18 Aug 2005 11:03:17 +0000 (GMT) (envelope-from albi@scii.nl) Received: from aseed.demon.nl ([83.160.138.119]:9963 helo=mail.aseed.antenna.nl) by post-25.mail.nl.demon.net with esmtp (Exim 4.51) id 1E5iB2-0005FJ-OJ; Thu, 18 Aug 2005 11:03:16 +0000 Received: from http.aseed.antenna.nl (unknown [192.168.0.50]) by mail.aseed.antenna.nl (Postfix) with ESMTP id 2BF08154432; Thu, 18 Aug 2005 13:11:18 +0200 (CEST) Received: from localhost.localdomain (217-19-30-147.dsl.cambrium.nl [217.19.30.147]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by http.aseed.antenna.nl (Postfix) with ESMTP id 4EE3558F737; Thu, 18 Aug 2005 13:02:58 +0200 (CEST) Date: Thu, 18 Aug 2005 13:03:09 +0200 From: "albi@scii.nl" To: vladone Message-Id: <20050818130309.54156544.albi@scii.nl> In-Reply-To: <571953085.20050818135236@spaingsm.com> References: <571953085.20050818135236@spaingsm.com> X-Mailer: Sylpheed version 1.0.4 (GTK+ 1.2.10; i386-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: i can't connect remote to my mysql server X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 18 Aug 2005 11:03:18 -0000 On Thu, 18 Aug 2005 13:52:36 +0300 vladone wrote: > 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. afaik by default it's only allowing 127.0.0.1 to access > 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. if you installed from ports, try looking in /usr/local/etc/ (almost) everything installed from ports has the /usr/local/ install-prefix pkg_info -L mysql-server* | less might also help