如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器,并使用mypassword作为密码应当执

分类: 高级技师单选题2 发布时间: 2023-12-01 12:13 浏览量: 0

如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器,并使用mypassword作为密码应当执行的命令是(____)。

A.GRANT ALL PRIVILEGES ON *.* TO 'myuser''192.168.1.3' IDENTIFIED BY 'mypassword’ WITH GRANT OPTION;

B.GRANT ALL PRIVILEGES ON . TO 'myuser''192.168.1.3' IDENTIFIED BY 'mypassword’ WITH GRANT OPTION;

C.GRANT ALL PRIVILEGES ON %.% TO 'myuser''192.168.1.3' IDENTIFIED BY 'mypassword’ WITH GRANT OPTION;

D.GRANT ALL PRIVILEGES ON . TO 'myuser''192.168.1.3' IDENTIFIED BY 'mypassword’ WITH GRANT OPTION;

正确答案是A