Resolution: Won't Fix
Affects Version/s: 5.6.40-84.0, 5.6.43-84.3
Fix Version/s: None
I'm trying to install the percona-server-server-5.6 package on Ubuntu 16.04 using the Ubuntu 16.04 repository provided by Percona.
We're preloading the mysql root password into debconf before installing, so it doesn't query for it. However, when using a password with double quotation marks ('"') in it, the postinst script fails to set the password:
`ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';'") WHERE user='root';' at line 1`
This error also occurs when providing the password manually at install time.
The percona-server-server-5.7 package installs and sets the root password correctly, even when using a double quotation mark.