How shall we connect to memsql Leaf nodes as a user, while i try to connect i get following error :
When I try to connect to leaf nodes I get Access denied for user ‘MEDICUBE_ETL_PROD_BATCHID’@‘10.203.228.122’ (using password: YES) is there as special setting require ?
My user has following grants :
memsql> show grants for ‘MEDICUBE_ETL_PROD_BATCHID’@’%’;
±------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for MEDICUBE_ETL_PROD_BATCHID@% |
±------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, FILE READ, SHOW VIEW ON . TO ‘MEDICUBE_ETL_PROD_BATCHID’@’%’ IDENTIFIED BY PASSWORD ‘8888888888888888’ |
| GRANT ALL PRIVILEGES ON MEDICUBE_BOB. TO ‘MEDICUBE_ETL_PROD_BATCHID’@’%’
Thanks
Tanvi