Wouldn't that depend on if the MySQL db is on the same server as the web
servers and the scripts that connect to them. It could also depend on if
the scripts use the -h option when making a connection and if this is the
ip address (as in number) or is a resolvable name. If it is all local, if
the grants use an ip number instead of localhost to give the needed
permissions then you might want to check that also.
I agree if you are using root to connect from web scripts etc you really
need to change this.
cheers,
noel
On Tuesday, July 10, 2001 11:34 AM, Rolf Hopkins
[SMTP:[EMAIL PROTECTED]] wrote:
> Changing your IP address shouldn't affect your MySQL access in that way.
I
> would say you have done something else to cause those errors. You can
look
> at skip grants in the manual. From what you have written, your web pages
> are accessing the DB as root. That spells D A N G E R. You should
create
> another user with less access.
>
> ----- Original Message -----
> From: "Kevin Robertson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 10, 2001 1:43
> Subject: mysql problem
>
>
> > I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer
have
> > access to the databases. I think i have lost access as root. Is there a
> > way to restore the root user password and/or change it to something
else
> > manually? I have many websites with many 'access denied' errors.
> >
> >
> > Any help would be appreciated.
> >
> > Thanks,
> > Kevin Robertson
> >
> >
> > ---------------------------------------------------------------------
> > 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
