Mysql新建用户并设置权限

CREATE USER usernameIDENTIFIED BY 'password';GRANT ALL PRIVILEGES ON *.* TO username@"%";flush privileges;