Need to migrate a oneclick reporting database.
However, the procedure does not seem to work.
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.251.252.14' IDENTIFIED BY 'MySqlR00t';
This gives: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Grant All Privileges with Grant option.
Release : 21.2
Component : Spectrum Reporting