From owner-freebsd-questions Sun Sep 1 13:43:54 2002 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 E8E6B37B400 for ; Sun, 1 Sep 2002 13:43:49 -0700 (PDT) Received: from jive.SoftHome.net (jive.SoftHome.net [66.54.152.27]) by mx1.FreeBSD.org (Postfix) with SMTP id 654C943E6A for ; Sun, 1 Sep 2002 13:43:49 -0700 (PDT) (envelope-from gsfgf@softhome.net) Received: (qmail 2827 invoked by uid 417); 1 Sep 2002 20:43:44 -0000 Received: from shunt-smtp-out-0 (HELO softhome.net) (172.16.3.12) by shunt-smtp-out-0 with SMTP; 1 Sep 2002 20:43:44 -0000 Received: from gentoo.my-net-space.net ([66.32.121.31]) (AUTH: LOGIN gsfgf@softhome.net) by softhome.net with esmtp; Sun, 01 Sep 2002 14:43:43 -0600 Date: Sun, 1 Sep 2002 16:52:05 +0000 From: Jeff Jeter To: "Pete Stapley" Cc: freebsd-questions@freebsd.org Subject: Re: Mysql won't let me in -- Update Message-Id: <20020901165205.0d3c22d3.gsfgf@softhome.net> In-Reply-To: <008001c251ec$2dd41280$0201a8c0@tar> References: <20020831114147.39c550b7.gsfgf@softhome.net> <3D70C959.19129.39875B56@localhost> <20020901151654.2ca551ad.gsfgf@softhome.net> <008001c251ec$2dd41280$0201a8c0@tar> X-Mailer: Sylpheed version 0.8.1 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG I did that, but still can't connect. I di have ftp, telnet, and nfs enabled. On Sun, 1 Sep 2002 13:17:13 -0600 "Pete Stapley" wrote: > First off, ftp, and telnet are disabled by default so that won't work unless > you turn them on, this is also true for nfs. To allow remote connections on > MySQL you need to send a SQL command to the database. Look in the MySQL docs > for the "GRANT" command. > > i.e. > GRANT ALL PRIVILEGES on database.tables to username@192.168.1.1 identified > by 'password'; > > ----- Original Message ----- > From: "Jeff Jeter" > To: "Corey Snow" > Cc: > Sent: Sunday, September 01, 2002 9:16 AM > Subject: Re: Mysql won't let me in -- Update > > > > I got it eorking locally, but when i try to connect remotely "mysql -h > server" it hangs. How do i allow access. I can't connect w/ ftp, nfs, or > telnet to this box either. my /etc/hosts.allow is "ALL : ALL : allow" > > > > > > On Sat, 31 Aug 2002 13:49:13 -0700 > > "Corey Snow" wrote: > > > > > On 31 Aug 2002, at 11:41, Jeff Jeter wrote: > > > > > > > I installed mysql, started it with safe_mysqld, and changed the root > password w/ mysql admin. mysqladmin -u root password ******** now when i > try to create a databas w/ mysql admin it won't accept a pass. > > > > > > > > mysqladmin create mini > > > > mysqladmin: connect to server at 'localhost' failed > > > > error: 'Access denied for user: ' root@localhost' (Using password:NO)' > > > > > > > > > > Try just > > > > > > %mysql -u root -p > > > > > > Which should prompt you for the password. You might also try > > > "root@servername" as the user ID, but that's a long shot. > > > > > > Corey > > > > > > > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > > with "unsubscribe freebsd-questions" in the body of the message > > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message