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
