MySQL Bugs: #82218: mysqlreplicate hangs while executing SHOW GRANTS for 'snuffles'@'host'

Bug #82218	mysqlreplicate hangs while executing SHOW GRANTS for 'snuffles'@'host'
Submitted:	13 Jul 2016 18:57	Modified:	22 Nov 2016 8:19
Reporter:	Steve Jackson	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Utilities	Severity:	S2 (Serious)
Version:	1.5.6	OS:	CentOS
Assigned to:		CPU Architecture:	Any
Tags:	mysqlreplicate

Description:
I was trying to set up replication between 2 VirtualBox VMs.  Everytime i executed "mysqlreplciate --master=user:pass@10.0.0.0 --slave=user:pass@10.0.0.1 --rpl-user=rep:pass" the system would hang.  I traced it down to the execution of the "SHOW GRANTS FOR 'snuffles'@'host' SQL statement.  The @ seems to give fits to mysql.  I modified the code to escape the @ and the command works and replication is set up.

How to repeat:
See description.

Suggested fix:
Escape the @ in the SQL statement.

Hi. Can you be more specific? Perhaps which area of the code you modified, which version of the server you are using, etc? Thanks.

Screenshot of source code

Attachment: Screen Shot 2016-07-14 at 9.46.59 AM.png (image/png, text), 109.04 KiB.

Screenshot of versions

Attachment: Screen Shot 2016-07-14 at 9.49.23 AM.png (image/png, text), 46.34 KiB.

The version of the server is 10.1.14.  The source file is server.py around line 2119.  I can't be sure the exact line because I was doing old fashioned debugging (print).  I have attached screen shots with this information.

Can you check that version of the server again? There is no MySQL version 10.

I was using MariaDB when I did this testing.  That is why the version number is 10.1.

Hello Steve Jackson,

Thank you for the bug feedback.
We are not supporting MariaDB, Please try with MySQL 5.7 GA and report if you have any issues.
Thank you for your interest in MySQL.
 
Thanks,
Chiranjeevi.