创建mysql用户
CREATE USER 'temp_account'@'%' IDENTIFIED BY '1234';
创建 用户: temp_account ip地址:'%' (代表任何地址) 密码:1234
如果报错:The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
输入:flush privileges;
赋予权限
增删查改
grant select on testdb.* to common_user@'%' grant insert on testdb.* to common_user@'%' grant update on testdb.* to common_user@'%' grant delete on testdb.* to common_user@'%'
或者
grant select, insert, update, delete on testdb.* to common_user@'%'