permission denied creating new user in jasperserver database

[sjongenelen]

 I was wondering can i create a new user in the jasperserver database? 

Im using mysql and connection with jasperdb@localhost and the matching password..

 

 

i need this user so i can quickly query which reports use which SQL query so i can locate these reports and edit them!

Code:

CREATE USER 'readonly'@'%';GRANT USAGE ON *.*  TO 'readonly'@'%'  IDENTIFIED BY 'password';GRANT SELECT ON *.* TO 'readonly'@'%';GRANT SHOW DATABASES ON *.* TO 'readonly'@'%';GRANT SHOW VIEW ON *.* TO 'readonly'@'%';

[sjongenelen]

Hmm, so to work around this, i've replaced the default MySQL engine with a newer one, overwritten root user password with mysqladmin and thus gaining control over the database engine.

 

howver, i hope this will not affect future update of JS wich perhaps use the root credentials....