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