Re: Connecting to mysqld
ya flush privileges OR restart the mysql server - Original Message - From: Carl-Johan Kihlbom [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: Connecting to mysqld
On torsdag, sep 26, 2002, at 02:43 Europe/Stockholm, Duncan Anker wrote: On Thu, 2002-09-26 at 07:06, Kirk Strauser wrote: At 2002-09-25T20:49:20Z, Carl-Johan Kihlbom [EMAIL PROTECTED] writes: I created the users with GRANT ALL ON *.* TO kihlbom IDENTIFIED BY 'password';. The users show up fine in the mysql.user table. Did you FLUSH PRIVILEGES after the addition? You don't need to do this if you use GRANT to set privileges. What else do you have set in your User table? What about the Db and Host tables? It worked when i specified the host, as in: GRANT ALL ON *.* to kihlbom@localhost. So now the user kihlbom can connect from localhost. But I would prefer it if that user could connect from any host. How do I do that? To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: Connecting to mysqld
# [EMAIL PROTECTED] / 2002-09-26 15:15:28 +0200: On torsdag, sep 26, 2002, at 02:43 Europe/Stockholm, Duncan Anker wrote: On Thu, 2002-09-26 at 07:06, Kirk Strauser wrote: At 2002-09-25T20:49:20Z, Carl-Johan Kihlbom [EMAIL PROTECTED] writes: I created the users with GRANT ALL ON *.* TO kihlbom IDENTIFIED BY 'password';. The users show up fine in the mysql.user table. Did you FLUSH PRIVILEGES after the addition? You don't need to do this if you use GRANT to set privileges. What else do you have set in your User table? What about the Db and Host tables? It worked when i specified the host, as in: GRANT ALL ON *.* to kihlbom@localhost. So now the user kihlbom can connect from localhost. But I would prefer it if that user could connect from any host. How do I do that? you already did, and your question reveals that you didn't bother reading the mysql manual. -- begin 666 nonexistent.vbs FreeBSD 4.7-RC 3:22PM up 8 days, 22:36, 17 users, load averages: 0.25, 0.17, 0.10 end To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: Connecting to mysqld
Hi there, On Thu, Sep 26, 2002 at 03:15:28PM +0200, Carl-Johan Kihlbom wrote: It worked when i specified the host, as in: GRANT ALL ON *.* to kihlbom@localhost. So now the user kihlbom can connect from localhost. But I would prefer it if that user could connect from any host. How do I do that? This is a bit risky from a security standpoint, but you could do this like so (for eg): grant select on dbname.* to username@% identified by password; OR grant select on dbname.* to username@%.myisp.net identified by password; Hope this helps, Marc To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: Connecting to mysqld
At 2002-09-25T20:49:20Z, Carl-Johan Kihlbom [EMAIL PROTECTED] writes: I created the users with GRANT ALL ON *.* TO kihlbom IDENTIFIED BY 'password';. The users show up fine in the mysql.user table. Did you FLUSH PRIVILEGES after the addition? -- Kirk Strauser In Googlis non est, ergo non est. To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
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 [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: Connecting to mysqld
On Thu, 2002-09-26 at 07:06, Kirk Strauser wrote: At 2002-09-25T20:49:20Z, Carl-Johan Kihlbom [EMAIL PROTECTED] writes: I created the users with GRANT ALL ON *.* TO kihlbom IDENTIFIED BY 'password';. The users show up fine in the mysql.user table. Did you FLUSH PRIVILEGES after the addition? You don't need to do this if you use GRANT to set privileges. What else do you have set in your User table? What about the Db and Host tables? -- Kirk Strauser In Googlis non est, ergo non est. To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message