From owner-freebsd-questions@FreeBSD.ORG  Thu Aug 18 13:15:28 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 8504A16A41F
	for <freebsd-questions@freebsd.org>;
	Thu, 18 Aug 2005 13:15:28 +0000 (GMT)
	(envelope-from nlamprecht@gmail.com)
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.200])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 1E7EC43D45
	for <freebsd-questions@freebsd.org>;
	Thu, 18 Aug 2005 13:15:27 +0000 (GMT)
	(envelope-from nlamprecht@gmail.com)
Received: by zproxy.gmail.com with SMTP id z6so263089nzd
	for <freebsd-questions@freebsd.org>;
	Thu, 18 Aug 2005 06:15:27 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=nY7VgYo+59mWmpsF6HpqyFTC/x+gZ4DTeChxlg3qdPdbshV7B3XB70tCx7uSmZrFo172KRhEwv1NW3Ih2zlKgJ0DQ+0TsQlHh5Xyakx0iopmrtIxZq6Lxmj5yrIKvOpvdIOtr6a+kbgZQ5WTaKeX33xIVGRnY4LknviYdaGMG9c=
Received: by 10.36.38.15 with SMTP id l15mr1021359nzl;
	Thu, 18 Aug 2005 06:15:27 -0700 (PDT)
Received: by 10.36.108.6 with HTTP; Thu, 18 Aug 2005 06:15:27 -0700 (PDT)
Message-ID: <7cbadc87050818061574cab72b@mail.gmail.com>
Date: Thu, 18 Aug 2005 15:15:27 +0200
From: Nelis Lamprecht <nlamprecht@gmail.com>
To: vladone <vladone@spaingsm.com>
In-Reply-To: <571953085.20050818135236@spaingsm.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <571953085.20050818135236@spaingsm.com>
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 <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 13:15:28 -0000

On 8/18/05, vladone <vladone@spaingsm.com> 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.

>=20
> 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.
>=20

Sample config files can be found in /usr/local/share/mysql. MySQL will
run fine with it's default settings but depending on your requirements
you may need to change them. You can copy one of the suitable sample
files to /var/db/mysql/my.cnf and change it according to your
requirements. You might also want to look at the phpMyAdmin port
/usr/ports/databases/phpmyadmin for a web gui front-end to MySQL where
you can add users and assign permissions with a click of a button.
Otherwise you'll have to do it manually as a previous post mentioned.

Cheers,
Nelis