RE: MySql Error Number 1130

2006-04-13 Thread Duzenbury, Rich
the (incorrect) socket? Thank you. Regards, Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 6:00 PM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 When you are trying to connect to port 3307, for example

Re: MySql Error Number 1130

2006-04-13 Thread gerald_clark
Duzenbury, Rich wrote: Wow, I found the problem! I think this may be a bug. In my case, I've got three instances running on ports 3306, 3307, and 3320. On the local machine, I connect to them via mysql -p --port-3306 --host=localhost mysql -p --port-3307 --host=localhost mysql -p

RE: MySql Error Number 1130

2006-04-13 Thread Duzenbury, Rich
localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would then be mutually

Re: MySql Error Number 1130

2006-04-13 Thread Barry
Duzenbury, Rich wrote: localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would

RE: MySql Error Number 1130

2006-04-13 Thread Duzenbury, Rich
-Original Message- From: Barry [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 9:41 AM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 Duzenbury, Rich wrote: localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut

RE: MySql Error Number 1130

2006-04-13 Thread Shawn Green
--- Duzenbury, Rich [EMAIL PROTECTED] wrote: -Original Message- From: Barry [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 9:41 AM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 Duzenbury, Rich wrote: localhost means socket

RE: MySql Error Number 1130

2006-04-13 Thread Duzenbury, Rich
Interesting. I have never heard of that option. LX09:/home/rduz/backup # mysql -p -h. --port=3307 Enter password: ERROR 2005 (HY000): Unknown MySQL server host '.' (1) Perhaps it no longer functions? Thanks. Regards, Rich -- MySQL General Mailing List For list archives:

MySql Error Number 1130

2006-04-12 Thread Duzenbury, Rich
Error Number 1130, Host 'nnn.nnn.nnn.nnn' is not allowed to connect to this MySQL server. I've been googling and reading manuals all day, and haven't made a dent. User Table *** 1. row *** Host: % User: root

Re: MySql Error Number 1130

2006-04-12 Thread mysql
, Duzenbury, Rich wrote: To: mysql@lists.mysql.com From: Duzenbury, Rich [EMAIL PROTECTED] Subject: MySql Error Number 1130 Hi all, I am setting up two additional instances of mysql on my mysql server, which is running version 5.0.18-standard-log. I've got the additional instances set up