Re: my host IP changed

2002-11-14 Thread Bruce Lewis
PROTECTED]>; "Mysql-L (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, November 14, 2002 2:05 PM Subject: Re: my host IP changed > Yes.You can put the new IP address instead of the name (no localhost).When > you make update, you must be sure that YOU DON'T REPLACE an

Re: my host IP changed

2002-11-14 Thread Gelu Gogancea
[EMAIL PROTECTED] - Original Message - From: "Chris Walcott" <[EMAIL PROTECTED]> To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Chris Walcott" <[EMAIL PROTECTED]>; "Mysql-L (E-mail)" <

RE: my host IP changed

2002-11-14 Thread Chris Walcott
Thursday, November 14, 2002 11:47 AM > To: Chris Walcott; Mysql-L (E-mail) > Subject: Re: my host IP changed > > > Hi, > > It's possible that in mysql.user table to exist the old IP > address of your > machine.You should check the field Host using: > > use

Re: my host IP changed

2002-11-14 Thread Gelu Gogancea
Hi, It's possible that in mysql.user table to exist the old IP address of your machine.You should check the field Host using: use mysql; select Host,User from user where User='YOUR_USER_NAME'; If in the Host field you see the '%' character that means your problem is not from MySQL... else you sh

Re: my host IP changed

2002-11-14 Thread Bruce Lewis
It is very possible. Your network may need an update as to what the new IP address is. Most networks take anywhere from 20-30 minutes to get the updates (depends upon your network administrators configuration). Another may be with your code. If you are using ODBC, you may need to change the cod