mysql创建用户和远程登录授权

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服务器