Bug #79976 | ERROR 1045 (28000): Access denied for user 'root'@'localhost' | ||
---|---|---|---|
Submitted: | 14 Jan 2016 3:49 | Modified: | 24 Mar 2016 3:23 |
Reporter: | bing xu | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.6.19 | OS: | CentOS |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
Tags: | mysql 1045 connection access spring springmvc mybatis |
[14 Jan 2016 3:49]
bing xu
[16 Jan 2016 6:09]
bing xu
I found in my.cnf there is: skip-grant-tables maybe it's the root cause? I delete it and not reproduced, but found another issue: "Packet for query is too large (8742 > 1024). You can change this value on the server by setting the 'max_allowed_packet' variable." I reset max_allowed_packet by command but it's changed back to 1024 after one day. no error, no exception, memory and disk space is enough. why max_allowed_packet will be reset after some time? and how to keep one value I set?
[16 Jan 2016 6:10]
bing xu
by the way, why "skip-grant-tablesa" should not be set in my.cnf?
[21 Mar 2016 22:08]
MySQL Verification Team
The skip-grant-tables option means that all privileges are ignored which leaves the service open to many forms of attack. This also places some restrictions on what can/can't be done. In any normal setup the skip-grant-tables should only be used to recover a system where the password is no longer known. As for the other issue, you are trying to send blobs or large text fields and the packet size is not large enough. Increase it using: max_allowed_packet=10M
[24 Mar 2016 3:23]
bing xu
solved. some unknown account from web changed my configuration and it's not reproduecd after I changed login account. regarding skip-grant-table, Jonathon is rihgt and thank you!