允许123的用户使用密码123来进行远程登录

GRANT ALL PRIVILEGES ON *.* TO '123'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;

允许123的用户在ip为192.168.0.1的主机上使用密码123来进行远程登录

GRANT ALL PRIVILEGES ON *.* TO '123'@'192.168.0.1' IDENTIFIED BY '123' WITH GRANT OPTION;

Logo

更多推荐