Bug #43103 ERROR 1045 (28000)

• Submitted: 23 Feb 2009 10:21
• Modified: 24 Mar 2009 10:51
• Reporter: Gonzales Jonathan
• Status: No Feedback
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.52
• OS: Linux (Red hat)
• 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".