Re: my host IP changed
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
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
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
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
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
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