创建用户
create user 'user_name'@'login_host' identified by 'passwd';
赋权
grant select on `db_name`.`table_name` to "user_name"@'login_host';
更新权限信息
flush privileges;
create user 'user_name'@'login_host' identified by 'passwd';
grant select on `db_name`.`table_name` to "user_name"@'login_host';
flush privileges;
SQL创建并赋予仅查询权限用户
https://liumou.site/doc/266