[MDEV-9491] Error when calling mysql_upgrade.exe: (another) User has no access permission Created: 2016-01-29 Updated: 2016-05-18 Resolved: 2016-05-18 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | OTHER |
| Affects Version/s: | 5.5.47 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Eid Badr | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | need_feedback | ||
| Environment: |
Windows 7 64-bit |
||
| Attachments: |
|
| Description |
|
Hi I got the following error when I call mysql_upgrade.exe user root@::1has no access permission (using password: no) |
| Comments |
| Comment by Elena Stepanova [ 2016-01-29 ] | |
|
It means what it says. Please check the login, password and permissions. | |
| Comment by Eid Badr [ 2016-02-01 ] | |
|
But I'm running the command using | |
| Comment by Elena Stepanova [ 2016-02-02 ] | |
|
The only thing that comes to mind at the moment is that you have some kind of pluggable authentication. Try to run select user, host, plugin from mysql.user to see if there is anything suspicious. You've set the affected version to 5.5.41, is it really the case? | |
| Comment by Eid Badr [ 2016-02-02 ] | |
|
I have checked again, it's version 5.5.47 here is the output of select user, host, plugin from mysql.user there is no root user | |
| Comment by Elena Stepanova [ 2016-03-01 ] | |
|
eidbadr, | |
| Comment by Eid Badr [ 2016-03-01 ] | |
|
yes the root is dropped, and I'm using another user to perform the operation. Is that not possible? Should the root be available to complete the opeartion? | |
| Comment by Elena Stepanova [ 2016-03-01 ] | |
|
Sorry, my bad, I forgot the nature of the problem – you are running upgrade under account leutek, but you get an error message about not being able to connect as root@'::1'. | |
| Comment by Elena Stepanova [ 2016-03-30 ] | |
|
eidbadr, please see the question above. | |
| Comment by Eid Badr [ 2016-04-04 ] | |
|
@Elena Stepanova I don't get the error in 5.5.48 anymore. Connecting via HeidiSQL and MySQLWorkbench using user leutek have always worked. output of SELECT CURRENT_USER(), USER() output of SHOW GRANTS
| |
| Comment by Elena Stepanova [ 2016-04-19 ] | |
|
I've got an idea what was going on there, but since it stopped happening for you, there is no way to check it. In this case I used U+00A0 symbol (non-breaking space) instead of all spaces on the command line except for the last one. Apparently it does not allow to read the options, so tools use default values; for mysql_upgrade the default user is root. I suppose it can be so not only with this particular symbol, but with some other ones as well. I don't know where they could have come from – maybe unusual keyboard layout, or unfortunate copy-paste, or anything like that. Do you think it could have happened in your case? | |
| Comment by Elena Stepanova [ 2016-05-18 ] | |
|
Please comment to re-open if you have further information on the issue. |