用户授权
GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE,EXECUTE ON *.* TO 'smarttourist_app'@'%' IDENTIFIED BY 'O5l@+oDqxl';
刷新权限
FLUSH PRIVILEGES;
查看用户权限
SHOW GRANTS FOR 'smarttourist_app'@'%';
用户授权
GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE,EXECUTE ON *.* TO 'smarttourist_app'@'%' IDENTIFIED BY 'O5l@+oDqxl';
刷新权限
FLUSH PRIVILEGES;
查看用户权限
SHOW GRANTS FOR 'smarttourist_app'@'%';