Bug #43103 ERROR 1045 (28000)
Submitted: 23 Feb 2009 10:21 Modified: 24 Mar 2009 10:51
Reporter: Gonzales Jonathan Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.52 OS:Linux (Red hat)
Assigned to: CPU Architecture:Any
Tags: access denied

[23 Feb 2009 10:21] Gonzales Jonathan
Description:
Hello everyboy,

I've a problem with my MySQL Server, i have install Mysql Monitor and i can't loggin on.
An error message appear and i have search a response for my problem but without response.
The message who appear is : 

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

This message result of : mysql -u root -p
If i write : mysql -u root, the message is ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

My password is correct but i can't connect to mysql.
Excuse me for my appromimativly english.

Please help me

How to repeat:
I have try to stop and restart mysqld
My file "my.cnf" contain :

[client]
port = 13306
socket =/var/lib/mysql/mysql.sock

[mysql]
port = 13306
no-auto-rehash
prompt = \u@\h [\d]>\_

[mysqld]
port = 13306
basedir = /opt/mysql/enterprise/monitor/mysql/
datadir = /opt/mysql/enterprise/monitor/mysql/data/
socket = /var/lib/mysql/mysql.sock
pid-file = /opt/mysql/enterprise/monitor/mysql/data/mysqld.pid

server-id = 1
secure_auth = 1
skip-locking
lower_case_table_names = 1

innodb_data_file_path = ibdata1:500M:autoextend
innodb_autoextend_increment = 50M
[23 Feb 2009 10:35] Valeriy Kravchuk
Please, try to connect with:

mysql -uroot -p --host=127.0.0.1 -P13306

and the same password. Inform about the results.
[23 Feb 2009 10:41] Gonzales Jonathan
i've try to connect with:

mysql -uroot -p --host=127.0.0.1 -P13306 and the same password.

It's the same result. I can't connect to mysql.
I can give you more details about my configuration and my differents files.

Thanks for your help
[23 Feb 2009 11:11] Valeriy Kravchuk
What exact version of MySQL server you are working with? Can you connect as any other user?
[23 Feb 2009 12:13] Gonzales Jonathan
With this command mysql -V, i see :

mysql  Ver 14.12 Distrib 5.0.52, for redhat-linux-gnu (i686) using readline 5.1

I haven't other user, the only is "root".

Thanks
[23 Feb 2009 12:36] Valeriy Kravchuk
Then, please, try to repeat with a newer version, 5.0.77, and inform about the results.
[23 Feb 2009 13:07] Gonzales Jonathan
Well, i think that's my problem is linked in with the slowness of my mysql dashboard.
I explain you : when i'am on my dashboard interface and when i want to open "monitor", it's very slow.
I think that this problem and the problem of connection are linked in.

Can you explain me the protocol to be followed to pass in version 5.0.77 without harming anything.

I hope not to have blended both problems

Thanks for your help
[24 Feb 2009 10:51] Sveta Smirnova
Thank you for the feedback.

Recommendations for safe upgrade of MySQL server are at http://dev.mysql.com/doc/refman/5.0/en/upgrade.html

But this looks like you try to connect to MySQL server installed by MySQL Enterprise Monitor. If is is so are you sure you have user root which allowed to connect to this server? Please consult file configuration_report.txt  located in your $INSTALL_PATH/mysql/enterprise/monitor directory for credentials.
[25 Mar 2009 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".