mysql> grant select,insert,update,delete,create,drop privileges on testdata.* to viewer@’172.16.1.1/255.255.255.0′ identified by ‘ T3nc3t!965.A ‘;

mysql> grant select,insert,update,delete,create,drop privileges on testdata.* to viewer@’172.16.1.1/255.255.255.0′ identified by ‘ T3nc3t!965.A ‘;