Bug #57968 Login with root user fails
Submitted: 4 Nov 2010 10:28 Modified: 10 Dec 2010 22:37
Reporter: Network Limited Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:Ver 14.14 Distrib 5.1.41 OS:Linux (Ubuntu 10.04.1 LTS)
Assigned to: CPU Architecture:Any

[4 Nov 2010 10:28] Network Limited 
Description:
WORKS
I can login with a user that I've created directly from the command line
i.e. mysql --user=testuser --password=testuserpassword

WORKS
I can login with the root user from the command line, but then have to type in the password at a prompt
i.e. mysql --user=root --password

FAILS
I can't login with the root user directly from the command line
i.e. mysql --user=root --password=rootpassword
The following error is encountered:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

How to repeat:
Attempt to login from the command line with the user and password parameters where the user is root
i.e. mysql --user=root --password=rootpassword

Suggested fix:
Login as expected without error
[10 Nov 2010 22:37] Sveta Smirnova 
Thank you for the report.

But version 5.1.41 is old. Please upgrade to current version 5.1.52, try with it and if problem still exists inform us if root password contains special symbols.
[11 Dec 2010 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".