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
