为指定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;
2022-10-10 18:21:43
为指定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;