Come to think of it, might it be that you are using an old mysql client,
possibly one that exists as part of an old installation of MySQL or in
the case of Linux, one that was installed as part of the Linux distro
installation?
Some of these older versions of MySQL Client does not support the more
secure password encryption methods used by newer MySQL versions, and you
will get just the errors that you are getting.
So if you are using Linux, do a "which mysql" and see what mysql client
you are using. Also do a "mysql --version" which will show the command
line client version. You have to watch for this if the client has
version 4.0 or earlier, and you have server with version 4.1 or higher,
then this is surely the problem you are experiencing.
Read more here:
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
Best regards
Anders Karlsson
Cornelia Menzel wrote:
Am 16.10.2006 um 13:23 schrieb Anders Karlsson:
The error shows that the passwords doesn't match. You just must have
made some mistake when resetting the password. But this can be fixed:
1) You can start the server with the --skip-grant-tables option that
disables password checking, then you log in as root, set the
password, and the restart the server without the --skip-grant-tables.
or
2) Use the --init-file option to run a file that resets the password.
Bith methods are described here:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
It is a rare occurence, but the problem might also be this:
http://dev.mysql.com/doc/refman/5.0/en/password-too-long.html
Best regards
Anders Karlsson
Thank you Anders, I have tried this already. But I will do it again,
perhaps I have more luck now.
Thank you.
Best regards,
Cornelia
---------------------------------------------
Cornelia Menzel
Spanien / España / Spain
e-Mail: [EMAIL PROTECTED]
http://www.corneliamenzel.com
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/ www.mysql.com Cellphone: +46 708 608121
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
