[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: PNG File image-2016-01-29-17-52-35-968.png     PNG File mdev9491.png     PNG File select current_user(), user().png     PNG File select user host plugin.png    

 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
-u leutek
why is it telling me that user root has no access permission?

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,
I assume it answers your question, right? Somebody or something dropped the root, you should re-create it.

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'.
It's bizarre.
Did you try to connect by MySQL client? Are you getting the same error?
Also, since you have this output from a GUI (HeidiSQL?), apparently you can connect via it. Are you using the same leutek account? Could you please run SELECT CURRENT_USER(), USER() and SHOW GRANTS there?

Comment by Elena Stepanova [ 2016-03-30 ]

eidbadr, please see the question above.
I don't want to close the issue as not repeatable, because obviously something weird is going on here, and it's worth digging into.

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

'GRANT ALL PRIVILEGES ON *.* TO \'leutek\'@\'%\' IDENTIFIED BY PASSWORD \'*EC9DC28A0F0B3AF8B1C752B6342A20E4EE272485\' WITH GRANT OPTION'

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.
I can reproduce the problem almost precisely:

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.

Generated at Thu Feb 08 07:35:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.