Date: Sun, 1 Sep 2002 16:52:05 +0000 From: Jeff Jeter <gsfgf@softhome.net> To: "Pete Stapley" <pstapley@rapidnet.com> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
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" <pstapley@rapidnet.com> 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" <gsfgf@softhome.net> > To: "Corey Snow" <corey@snowpoint.com> > Cc: <freebsd-questions@freebsd.org> > 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" <corey@snowpoint.com> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020901165205.0d3c22d3.gsfgf>