MySQL 5.6 syntax error with revoke
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack DBaaS (Trove) |
Fix Released
|
Undecided
|
Mat Lowery |
Bug Description
The current MySQL guest agent, which mostly works with MySQL 5.6, issues the following REVOKE SQL:
REVOKE ALL ON `tintin`.* FROM `tico`@`%` IDENTIFIED BY PASSWORD '*FA5CD0D6C1C6F
On MySQL 5.6, this results in a syntax error.
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 ''*FA5CD0D6C1C6
You can reproduce with the following SQL on MySQL 5.5 and 5.6 without using Trove:
create database testdb1;
use testdb1;
CREATE USER 'mat'@'%' IDENTIFIED BY 'password';
GRANT ALL ON testdb1.* TO mat@'%' IDENTIFIED BY PASSWORD '*2470C0C06DEE4
REVOKE ALL ON testdb1.* FROM mat@'%' IDENTIFIED BY PASSWORD '*2470C0C06DEE4
The following works on both MySQL 5.5 and 5.6:
REVOKE ALL ON testdb1.* FROM mat@'%'
Neither the 5.5 nor the 5.6 documentation mentions IDENTIFIED BY in REVOKE:
* http://
* http://
description: | updated |
Changed in trove: | |
milestone: | none → icehouse-rc1 |
status: | Fix Committed → Fix Released |
Changed in trove: | |
milestone: | icehouse-rc1 → 2014.1 |
Fix proposed to branch: master /review. openstack. org/80694
Review: https:/