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: | |
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
[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