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
code in that area as well if you are specifying an IP address.

This is for a Windows environment though, but it should be similar to Unix
as well.

Bruce



- Original Message -
From: Chris Walcott [EMAIL PROTECTED]
To: Mysql-L (E-mail) [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 1:22 PM
Subject: my host IP changed


 I just got mysql up and running (I'm a new user).  I'm using it with
ColdFusionMX.

 Just as I was about to bind a database to coldfusion, my IT department
decided to move my server to a new IP address.

 Now I can't get a database to bind to coldFusion and I'm wondering if it's
because the IP address changed.  Is this something that is stored in the
mysql database?

 If so, how so I change that?  I'd rather not have to rerun
mysql_install_db.

 - chris

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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 should to update the new IP address in the
mysql.user table using update or replace.
Finally you must do:
flush privileges;

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Chris Walcott [EMAIL PROTECTED]
To: Mysql-L (E-mail) [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 9:22 PM
Subject: my host IP changed


 I just got mysql up and running (I'm a new user).  I'm using it with
ColdFusionMX.

 Just as I was about to bind a database to coldfusion, my IT department
decided to move my server to a new IP address.

 Now I can't get a database to bind to coldFusion and I'm wondering if it's
because the IP address changed.  Is this something that is stored in the
mysql database?

 If so, how so I change that?  I'd rather not have to rerun
mysql_install_db.

 - chris

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: my host IP changed

2002-11-14 Thread Chris Walcott 
right now the host field has 2 entries: localhost and newpop (the name of the server). 
 There are no IP numbers.  Should I replace the host name entry with the new IP 
address?

thanks!

- chris

 -Original Message-
 From: Gelu Gogancea [mailto:ggelu;arctic.ro]
 Sent: 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 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 should to update the new IP address in the
 mysql.user table using update or replace.
 Finally you must do:
 flush privileges;
 
 Regards,
 
 Gelu
 _
 G.NET SOFTWARE COMPANY
 
 Permanent e-mail address : [EMAIL PROTECTED]
   [EMAIL PROTECTED]
 - Original Message -
 From: Chris Walcott [EMAIL PROTECTED]
 To: Mysql-L (E-mail) [EMAIL PROTECTED]
 Sent: Thursday, November 14, 2002 9:22 PM
 Subject: my host IP changed
 
 
  I just got mysql up and running (I'm a new user).  I'm using it with
 ColdFusionMX.
 
  Just as I was about to bind a database to coldfusion, my IT 
 department
 decided to move my server to a new IP address.
 
  Now I can't get a database to bind to coldFusion and I'm 
 wondering if it's
 because the IP address changed.  Is this something that is 
 stored in the
 mysql database?
 
  If so, how so I change that?  I'd rather not have to rerun
 mysql_install_db.
 
  - chris
 
  
 -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail 
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: 
 http://lists.mysql.com/php/unsubscribe.php
 
 
 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: my host IP changed

2002-11-14 Thread Gelu Gogancea 
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 and the record
where the Host field is 'localhost'.You must replace only the record where
in Host field is the name of computer/server which must connect to the
MySQL.
You can use :
update user SET Host='YOUR_IP_ADDRESS' where User='YOUR_USER_NAME' and
Host='THE_NAME_OF_HOST';

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Chris Walcott [EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; Chris Walcott
[EMAIL PROTECTED]; Mysql-L (E-mail) [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 9:52 PM
Subject: RE: my host IP changed


 right now the host field has 2 entries: localhost and newpop (the name of
the server).  There are no IP numbers.  Should I replace the host name entry
with the new IP address?

 thanks!

 - chris

  -Original Message-
  From: Gelu Gogancea [mailto:ggelu;arctic.ro]
  Sent: 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 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 should to update the new IP address in the
  mysql.user table using update or replace.
  Finally you must do:
  flush privileges;
 
  Regards,
 
  Gelu
  _
  G.NET SOFTWARE COMPANY
 
  Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
  - Original Message -
  From: Chris Walcott [EMAIL PROTECTED]
  To: Mysql-L (E-mail) [EMAIL PROTECTED]
  Sent: Thursday, November 14, 2002 9:22 PM
  Subject: my host IP changed
 
 
   I just got mysql up and running (I'm a new user).  I'm using it with
  ColdFusionMX.
  
   Just as I was about to bind a database to coldfusion, my IT
  department
  decided to move my server to a new IP address.
  
   Now I can't get a database to bind to coldFusion and I'm
  wondering if it's
  because the IP address changed.  Is this something that is
  stored in the
  mysql database?
  
   If so, how so I change that?  I'd rather not have to rerun
  mysql_install_db.
  
   - chris
  
  
  -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail
  [EMAIL PROTECTED]
   Trouble unsubscribing? Try:
  http://lists.mysql.com/php/unsubscribe.php
  
  
 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: my host IP changed

2002-11-14 Thread Bruce Lewis 
One other simple task that you can try is to just perform a ping.  If you
can ping the server with the new IP address, then your network is not the
problem.

Bruce



- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Chris Walcott [EMAIL 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 and the record
 where the Host field is 'localhost'.You must replace only the record where
 in Host field is the name of computer/server which must connect to the
 MySQL.
 You can use :
 update user SET Host='YOUR_IP_ADDRESS' where User='YOUR_USER_NAME' and
 Host='THE_NAME_OF_HOST';

 Regards,

 Gelu
 _
 G.NET SOFTWARE COMPANY

 Permanent e-mail address : [EMAIL PROTECTED]
   [EMAIL PROTECTED]
 - Original Message -
 From: Chris Walcott [EMAIL PROTECTED]
 To: 'Gelu Gogancea' [EMAIL PROTECTED]; Chris Walcott
 [EMAIL PROTECTED]; Mysql-L (E-mail) [EMAIL PROTECTED]
 Sent: Thursday, November 14, 2002 9:52 PM
 Subject: RE: my host IP changed


  right now the host field has 2 entries: localhost and newpop (the name
of
 the server).  There are no IP numbers.  Should I replace the host name
entry
 with the new IP address?
 
  thanks!
 
  - chris
 
   -Original Message-
   From: Gelu Gogancea [mailto:ggelu;arctic.ro]
   Sent: 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 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 should to update the new IP address in the
   mysql.user table using update or replace.
   Finally you must do:
   flush privileges;
  
   Regards,
  
   Gelu
   _
   G.NET SOFTWARE COMPANY
  
   Permanent e-mail address : [EMAIL PROTECTED]
 [EMAIL PROTECTED]
   - Original Message -
   From: Chris Walcott [EMAIL PROTECTED]
   To: Mysql-L (E-mail) [EMAIL PROTECTED]
   Sent: Thursday, November 14, 2002 9:22 PM
   Subject: my host IP changed
  
  
I just got mysql up and running (I'm a new user).  I'm using it with
   ColdFusionMX.
   
Just as I was about to bind a database to coldfusion, my IT
   department
   decided to move my server to a new IP address.
   
Now I can't get a database to bind to coldFusion and I'm
   wondering if it's
   because the IP address changed.  Is this something that is
   stored in the
   mysql database?
   
If so, how so I change that?  I'd rather not have to rerun
   mysql_install_db.
   
- chris
   
   
   -
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)
   
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
   [EMAIL PROTECTED]
Trouble unsubscribing? Try:
   http://lists.mysql.com/php/unsubscribe.php
   
   
  
 


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php