CREATE USER 'username'@'host' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'host' IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES;
host可以用%代替,表示允许所有ip使用该username远程登录mysql服务器