auth error

[Nathan]

Admittedly, I am a newbie, and I think i might have really screwed up
here. I installed mysql using the package update quite from RH 9.0,
and wanted to set root to have a password for logging into mysql. I
ran this script from the mysql web site:

shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
-> WHERE user='root';
mysql> FLUSH PRIVILEGES;

and my actual commands looked like this:

shell> mysql -u root mysql
mysql> UPDATE user SET Password='redfish'
-> WHERE user='root';
mysql> FLUSH PRIVILEGES;

Now, when i try to log in using:

mysql mysql -p or mysql -uroot mysql -p or anything similar i get this
back:

ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)

Is there anyway i can recover? Thanks in advance for any help or
suggestions.

Nathan Weast

[ChangAya]

since mysql use crypt password.. so you can't find your password..

solve.

1. shutdown mysql
2. start mysql with --skip-grant-tables option

--skip-grant-tables
This option causes the server not to use the privilege system at all.
This gives everyone full access to all databases! (You can tell a
running server to start using the grant tables again by executing
mysqladmin flush-privileges or mysqladmin reload.)

then.. you set root password correct..

nw****@ficgroup.com (Nathan) wrote in message news:<a3*************************@posting.google.c om>...

Admittedly, I am a newbie, and I think i might have really screwed up
here. I installed mysql using the package update quite from RH 9.0,
and wanted to set root to have a password for logging into mysql. I
ran this script from the mysql web site:

shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
-> WHERE user='root';
mysql> FLUSH PRIVILEGES;

and my actual commands looked like this:

shell> mysql -u root mysql
mysql> UPDATE user SET Password='redfish'
-> WHERE user='root';
mysql> FLUSH PRIVILEGES;

Now, when i try to log in using:

mysql mysql -p or mysql -uroot mysql -p or anything similar i get this
back:

ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)

Is there anyway i can recover? Thanks in advance for any help or
suggestions.

Nathan Weast

[ChangAya]

since mysql use crypt password.. so you can't find your password..

solve.

1. shutdown mysql
2. start mysql with --skip-grant-tables option

--skip-grant-tables
This option causes the server not to use the privilege system at all.
This gives everyone full access to all databases! (You can tell a
running server to start using the grant tables again by executing
mysqladmin flush-privileges or mysqladmin reload.)

then.. you set root password correct..

nw****@ficgroup.com (Nathan) wrote in message news:<a3*************************@posting.google.c om>...

Admittedly, I am a newbie, and I think i might have really screwed up
here. I installed mysql using the package update quite from RH 9.0,
and wanted to set root to have a password for logging into mysql. I
ran this script from the mysql web site:

shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
-> WHERE user='root';
mysql> FLUSH PRIVILEGES;

and my actual commands looked like this:

shell> mysql -u root mysql
mysql> UPDATE user SET Password='redfish'
-> WHERE user='root';
mysql> FLUSH PRIVILEGES;

Now, when i try to log in using:

mysql mysql -p or mysql -uroot mysql -p or anything similar i get this
back:

ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)

Is there anyway i can recover? Thanks in advance for any help or
suggestions.

Nathan Weast