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
[EMAIL PROTECTED]
- Original Message -
From: "Chris Walcott" <[EMAIL PROTECTED]>
To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Chris Walcott"
<[EMAIL PROTECTED]>; "Mysql-L (E-mail)" <
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
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
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