为指定IP授权

GRANT ALL PRIVILEGES ON *.* TO ‘userName‘@‘ip‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION;

泛授权

GRANT ALL PRIVILEGES ON *.* TO ‘userName‘@‘%‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION;

mysql授权