On 21-Mar-01 Jared Rogge wrote:
> Does anybody know how to
> reset or disable this feature if you have root access to the machine?
>
localhost.dread$ grep skip-grant $MANUAL
`--skip-grant-tables' option and add the privilege information
s
Restart mysqld with the --skip-grant-tables option, this will allow you to
bypass mysql's authentication. You can log in as root and then change the
password to something else.
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Wed, 21 Mar 2001, Jared Rogge wrote:
hi.
log in as root, kill the mysqld process.
restart mysqld with the --skip-grant option.
once it is running you can connect and alter the password directly in the
'mysql' table.
maybe a flush privileges to reload the permissions after that?
you really just forgot the password you typed, didn't
>password to MySQL and I cannot into it of course. Does anybody know how to
>reset or disable this feature if you have root access to the machine?
Read the manual you can find at http://www.mysql.com
This is explained into great detail.
Bye,
B.
-
