Re: mySQL password file.
| From: | Troels Arvin | Date: | Sun, 25 Jun 2000 18:07:58 +0000 |
| Subject: | Re: mySQL password file. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-3013@lists.php.net to get a copy of this message | ||
Adam Charnock <adamcharnock@btinternet.com> wrote:
> Can anyone tell me which file on my ded. server is likely to have the mySQL
> encrypted password and login in it?
/var/lib/mysql/mysql/user.ISD
However, it's not a plain-text file.
If you have lost your root-password to the MySQL server, then
1) close it,
2) re-start it with the --skip-grant-tables option,
3) log into MySQL as root and give root a new password; finally:
4) re-start the MySQL server in the normal way
--
Greetings from Troels Arvin, Copenhagen, Denmark