Three water cannon bought for the Met Police force for hundreds of thousands of pounds are set to be sold off - without ever being used.
New London Mayor Sadiq Khan announced the move just under a year after Home Secretary Theresa May blocked the deployment of the equipment.
Her ruling was hugely embarrassing for Mr Khan's predecessor Boris Johnson, who had authorised the purchase of three second-hand cannon for Scotland Yard from German police at a cost of more than £200,000 before they were cleared for use.
Mr Johnson faced fresh mocking over the episode earlier on Thursday as Mrs May launched her bid to succeed David Cameron as Tory leader.
She said: "Boris negotiated in Europe. I seem to remember last time he did a deal with the Germans, he came back with three nearly-new water cannon."
The Home Secretary announced in the Commons in July last year that she was refusing permission for police to deploy water cannon to control riots and serious public disorder.
Mr Johnson admitted he disagreed with Mrs May's stance, while the Metropolitan Police expressed its "disappointment".
Water cannon have never been used on the British mainland, although they have been deployed in Northern Ireland.
Calls for police to have access to them first emerged in light of the riots in 2011.
At the time use of the cannon was vetoed, Scotland Yard said they would be used for training.