首页 试题详情
单选题

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

AGRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘192.168.1.3‘ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION

BGRANT ALL PRIVILEGES ON @.@ TO ‘myuser‘@‘192.168.1.3‘ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION

CGRANT ALL PRIVILEGES ON %.% TO ‘myuser‘@‘192.168.1.3‘ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION

DGRANT ALL PRIVILEGES ON . TO ‘myuser‘@‘192.168.1.3‘ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION

正确答案:A (备注:此答案有误)

相似试题

  • 单选题

    如果你想允许用户myuserip192.168.1.3的主机连接到mysql服务器,并使用mypassword作为密码应当执行的命令是:

    答案解析

热门题库