Date: Thu, 26 Sep 2002 02:22:08 +0530 From: "Unix Tools" <unixtools@hotmail.com> To: "Carl-Johan Kihlbom" <div@newcode.se>, <questions@FreeBSD.ORG> Subject: Re: Connecting to mysqld Message-ID: <OE47ca0ZkfzDskqC5Et00000da1@hotmail.com> References: <43D6BC90-D0C8-11D6-A206-00039363CBAA@newcode.se>
next in thread | previous in thread | raw e-mail | index | archive | help
ya flush privileges OR restart the mysql server ----- Original Message ----- From: "Carl-Johan Kihlbom" <div@newcode.se> To: <questions@FreeBSD.ORG> Sent: Thursday, September 26, 2002 02:19 AM Subject: Connecting to mysqld > I'm having trouble connecting to mysqld on my FreeBSD server. > > If i connect as root using mysql -u root -p it works just fine, but if > I try as any other user, e.g. mysql -u kihlbom -p I get the following > error message: > > ERROR 1045: Access denied for user: 'kihlbom@localhost' (Using > password: YES) > > I created the users with "GRANT ALL ON *.* TO kihlbom IDENTIFIED BY > 'password';". The users show up fine in the mysql.user table. > > Is there a config file somewhere that states that only root may connect? > > How can I allow connections from all users with a valid password? > > > 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?OE47ca0ZkfzDskqC5Et00000da1>