How to create a new user in memsql

Help Security
1

I created a user using the below sql stmts but still the user cant access remotely from sqldbx tool .

CREATE USER ‘california’@’%’ IDENTIFIED BY ‘Tesla123#’;
grant group ‘am_data_read_only_group’ to ‘california’@’%’;
grant group ‘am_data_read_write_group’ to ‘california’@’%’;
GRANT ALL PRIVILEGES ON . TO ‘california’@’%’ WITH GRANT OPTION;

Pls let me know what else I need to do.

2

Can you log in as user california from the mysql command prompt? What error are you getting?

3

The problem was with the AWS security groups which was not allowing to connect from the laptop .
The same thing works when connected to on-prem servers.
Thanks for responding. We can close this thread.