Home / server / Questions / 424871
In Process
IssamTP
Asked: 2012-09-07 01:41:34 +0800 CST

MySQL ERROR 1045 (28000)

  • 772

EDIT:

I have found a solution, even if we can't talk exactly of solution. Well, I used RevoUninstaller to remove the MySQL Server, then I've proceed with a standard installation and everything got solved. Then, I've repeated all the steps above, adding each time a customization. I finally found that the error comes out when I chose default character set to ucs2 instead of latin1. Even If the problem is solved, I'll leave the question open for further and more detailed answers.

END EDIT.

I've tried to update MySQL Server from version 5.1 to 5.5 to get rid of a bug in a program. After a first try, the situation was worst than I have expected: the program can't log in with root user anymore and so Workbench and console. In the latter case, the error was:

c:\mypathtosql>mysql -u root -p
Enter password:******
ERROR 1045 (28000):

Yes, after ERROR 1045 (28000) there were no details. I decided to completely remove the package (which include a manual removing of all reg keys) and then to install it again. This workaround worked for Workbench, but my program can't do the user creation from a script with no error apparently (I get an error "Can't find any matching row in the user table", but I guess this happen late in the script when I log with the appropriate user), and also the console persist to give the error described above.

Everything seems to work fine with MySQL Workbench...

Hints, suggestions?

Thank you in advance.

windows

2 Answers

  1. I know this question is already gone out of our concern, because it's 1 years old. But I want to leave some information what I found to let help someone who get pain with this problem like me or us.

    I've suffered with this problem and after reinstalling MySQL 5.5 sometimes, I found a solution. This is not a problem with any permission(incl flush permissions) or password reset.

    Simply, the problem is 'ucs2' on windows version of MySQL client application(mysql.exe).

    To logon normally, you need to modify your my.ini file.

    1. Open my.ini in your MySQL installation path
    2. Find 'default-character-set' in [mysql] section.
    3. It's value would be 'ucs2'. Modify its value to 'utf8' or 'latin1' and save.

    After this, you would be able to logon to your MySQL instance.

    • 1

  2. You can just reset the mysql root password, here are some links showing how to do that:
    http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
    http://www.cyberciti.biz/tips/recover-mysql-root-password.html

    • 0