默认情况下，Azure托管的MySQL 5.6/5.7的binlog_row_image为MINIMAL。尝试通过Azure CLI将其设置为FULL时遇到错误。尝试修改配置或在MySQL命令行中执行全局设置都失败，因为缺少SUPER权限。解决方案是使用SQL语句：SET SESSION binlog_row_image='FULL'来临时更改。
The default binlog_row_image for Azure hosted MySQL versions 5.6/5.7 is MINIMAL. I would like to set the variable to FULL. Running the following commands on Azure CLI failed:
test@Azure:~$ az mysql server configuration set --name binlog_row_image --value 'FULL' --server-name five-six-test
Deployment failed. Correlation ID: e3138606-3bdf-4c89-8750-71aebca8192b. The configuration 'binlog_row_image' does not exist for MySQL server version 5.6.
test@Azure:~$ az mysql server configuration set --name @@binlog_row_image --value 'FULL' --server-name five-six-test
Deployment failed. Correlation ID: 0a243c69-05f0-471a-a430-696cd55642a5. The configuration '@@binlog_row_image' does not exist for MySQL server version 5.6.
test@Azure:~$ az mysql server configuration set --name @@binlog_row_image --value '
最低0.47元/天 解锁文章
869
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
