[MDEV-4510] ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Created: 2013-05-11 Updated: 2013-05-31 Due: 2013-05-25 Resolved: 2013-05-31 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 5.5.30 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Olaf Seebe | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | None | ||
| Description |
|
|
| Comments |
| Comment by Elena Stepanova [ 2013-05-11 ] |
|
Hi Wlad, Could you please take a look at the thread by the link to see if there is any useful information in German, before I start asking questions? |
| Comment by Sergei Golubchik [ 2013-05-11 ] |
|
First, MySQL exhibit exactly the same behavior. Second, the reason probably is — you've migrated from 5.1, and 5.5 adds new privileges, may be you didn't upgrade properly. Either way — your 'root' user does not have ALL privileges, so it cannot grant them to anyone. Verify with SHOW GRANTS or with SELECT * FROM mysql.user and fix that with UPDATE mysql.user |
| Comment by Elena Stepanova [ 2013-05-22 ] |
|
Hi Olaf, Was the comment above a sufficient explanation? Did you manage to resolve the problem? Thanks. |
| Comment by Elena Stepanova [ 2013-05-31 ] |
|
Closing as Incomplete for now. Please comment to re-open if you still have questions. |