Bug #89212 # master on pppzmy01-sql01-vip.dit.umontreal.ca: ... ERROR: Access denied for us
Submitted: 12 Jan 2018 16:28 Modified: 27 Feb 2018 14:23
Reporter: Madjid Sellam Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.6.38 OS:Oracle Linux
Assigned to: MySQL Verification Team CPU Architecture:Any

[12 Jan 2018 16:28] Madjid Sellam
Description:
1- After upgrading MySQL Server from 5.6.21 to 5.6.38, I tried to reactive the replication process but i received the following issue:

# master on pppzmy01-sql01-vip.dit.umontreal.ca: ...
ERROR: Access denied for user 'root'@'richmond-pp-bd.dit.umontreal.ca' (using password: YES)

2- After that I dropped and recreate the replication process between master and slave server. I received the same issue.

# master on pppzmy01-sql01-vip.dit.umontreal.ca: ...
ERROR: Access denied for user 'root'@'richmond-pp-bd.dit.umontreal.ca' (using password: YES)

How to repeat:

mysqlreplicate --rpl-user=replication-pppzmy01_sql01 --master=pppzmy01_sql01 --slave=sppzmy01_sql01 --master-log-file=mysql-bin.003504 --master-log-pos=183854
[19 Jan 2018 15:24] MySQL Verification Team
Hi,
I need more info on this problem you are having.

> mysqlreplicate --rpl-user=replication-pppzmy01_sql01 

so we'r talking replication-pppzmy01_sql01 not root

but you get "Access denied for user 'root'@'..."

so questions
 - how did you upgrade? dump/restore or in-place?
 - did you upgrade both master and slave or?
 - what you do when you get the root@ auth error?

all best
Bogdan
[19 Jan 2018 15:36] Madjid Sellam
Hi,

When I test the mysql connection using login-path replication-pppzmy01_sql01 the login works fine.

I don't have any idea about this error: "Access denied for user 'root'@'..."

so questions
 - how did you upgrade? dump/restore or in-place?

 In-place upgrade

 - did you upgrade both master and slave or?

 Both Master and Slave are upgraded to 5.6.38

 - what you do when you get the root@ auth error?

I can not see anything but the replication is not created and I get this error. I do not have a car idea I tested all the login-patch that I have with mysql and it works against against the replication commands it does not work!

Thank you for your Help!
Madjid
[26 Jan 2018 15:58] MySQL Verification Team
Hi,
I'm sorry but it is still unclear what do you do exactly before you get this error. I can't reproduce this at all.

all best
Bogdan
[27 Feb 2018 1: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".
[27 Feb 2018 14:02] Madjid Sellam
Hi,

When I test the mysql connection using login-path replication-pppzmy01_sql01 the login works fine.

I don't have any idea about this error: "Access denied for user 'root'@'..."

so questions
 - how did you upgrade? dump/restore or in-place?

 In-place upgrade

 - did you upgrade both master and slave or?

 Both Master and Slave are upgraded to 5.6.38

 - what you do when you get the root@ auth error?

I can not see anything but the replication is not created and I get this error. I do not have a car idea I tested all the login-patch that I have with mysql and it works against against the replication commands it does not work!

Thank you for your Help!
Madjid
[27 Feb 2018 14:05] MySQL Verification Team
Hi,

You just c/p the last reply that does not clearly explain what exactly did you do to get this error

all best
Bogdan
[27 Feb 2018 14:06] Madjid Sellam
Hi,

I need fix this issue to do the upgrade for production site from 5.6.21 to 5.6.38

Best regards,
Madjid Sellam
[27 Feb 2018 14:23] MySQL Verification Team
Hi,
I still don't understand what your problem is but contacted colleagues and maybe you have login path named "pppzmy01_sql01" which contains user=root

if that's it you need to: mysql --login-path=pppzmy01_sql01 -e "show grants"
to see what grants you have there

all best
Bogdan