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
