What are the privileges required for the table grid when connecting to a mysql database ?
There are 2 points regarding this question
If the user is using jira as datasource, i.e
gd.ds=jira
or
col.<column name>.query.ds=jira
there is no need to worry about permissions because jira is providing the plugin with the connection and the plugin doesn't need neither username nor password
If some other mysql datasource is configured, for example
gd.columns=alist col.alist=list col.alist.type=list col.alist.query=select plane_name from test_data col.alist.query.ds=gridds datasource.names=gridds ds.gridds.connection.type=mysql ds.gridds.connection.url=jdbc:mysql://localhost:3306/igrid_test?useUnicode=true&characterEncoding=UTF8&jdbcCompliantTruncation=false ds.gridds.connection.username=igrid_tester ds.gridds.connection.password=igrid_tester
Then the user has to be sure that there is a user igrid_tester at localhost identified by password 'igrid_tester' and that this 'igrid_tester' user has following privileges on all tables of the schema which is used (igrid_test in our case):
- CREATE
- DROP
- ALTER
- SELECT
- INSERT
- UPDATE
- DELETE
INDEX
Here is how you can create and setup privileges for such a user in mysql:
CREATE USER `igrid_tester`@`localhost`; SET PASSWORD FOR `igrid_tester`@`localhost` = PASSWORD('igrid_tester'); GRANT CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE, INDEX ON `igrid_test`.* TO `igrid_tester`@`localhost`;