• 2022-06-03 问题

    下面使用DROP USER语句删除用户user1的语句中,正确的是 A: DROP USER user1@localhost; B: DROP USER 'user1'.’ocalhost'; C: DROP USER user1.localhost; D: DROP USER 'user1'@'localhost';

    下面使用DROP USER语句删除用户user1的语句中,正确的是 A: DROP USER user1@localhost; B: DROP USER 'user1'.’ocalhost'; C: DROP USER user1.localhost; D: DROP USER 'user1'@'localhost';

  • 2022-06-07 问题

    实现将root用户的密码修改为'1111'的语句,正确的是() A: alter user 'root'@'localhost' identified by ‘1111’; B: alter user 'root'@'localhost' identified by 1111; C: alter user 'root'@'localhost' =‘1111’; D: set user 'root'@'localhost' =‘1111’;

    实现将root用户的密码修改为'1111'的语句,正确的是() A: alter user 'root'@'localhost' identified by ‘1111’; B: alter user 'root'@'localhost' identified by 1111; C: alter user 'root'@'localhost' =‘1111’; D: set user 'root'@'localhost' =‘1111’;

  • 2022-06-18 问题

    下面使用DELETE语句删除用户user2的语句中,正确的是 A: DELETE FROM mysql.user WHERE Host='localhost' AND User='user2'; B: DELETE FROM mysql.user WHILE Host='localhost' AND User='user2'; C: DELETE FROM mysql.user WHERE Host='localhost' OR User='user2'; D: DELETE FROM mysql.user WHILE Host='localhost' OR User='user2';

    下面使用DELETE语句删除用户user2的语句中,正确的是 A: DELETE FROM mysql.user WHERE Host='localhost' AND User='user2'; B: DELETE FROM mysql.user WHILE Host='localhost' AND User='user2'; C: DELETE FROM mysql.user WHERE Host='localhost' OR User='user2'; D: DELETE FROM mysql.user WHILE Host='localhost' OR User='user2';

  • 2022-06-07 问题

    下面通过UPDATE语句将root用户的密码修改为mypwd2的语句中,正确的是 A: UPDATE mysql.user SET Password=PASSWORD('mypwd2') WHERE User='root' and Host='localhost'; B: UPDATE mysql.users SET Password=PASSWORD('mypwd2') WHERE User='root' and Host='localhost'; C: UPDATE mysql.users SET Password=PASSWORD('mypwd2') WHERE User='root' OR Host='localhost'; D: UPDATE mysql.user SET Password=PASSWORD('mypwd2') WHILE User='root' OR Host='localhost';

    下面通过UPDATE语句将root用户的密码修改为mypwd2的语句中,正确的是 A: UPDATE mysql.user SET Password=PASSWORD('mypwd2') WHERE User='root' and Host='localhost'; B: UPDATE mysql.users SET Password=PASSWORD('mypwd2') WHERE User='root' and Host='localhost'; C: UPDATE mysql.users SET Password=PASSWORD('mypwd2') WHERE User='root' OR Host='localhost'; D: UPDATE mysql.user SET Password=PASSWORD('mypwd2') WHILE User='root' OR Host='localhost';

  • 2022-06-19 问题

    使用CREATE USER语句创建一个新用户,用户名为user2、密码为123 下面选项中,能实现上述功能的语句是 A: CREATE USER 'user2'@'localhost' IDENTIFIED BY '123'; B: CREATE USER user2@localhost IDENTIFIED BY 123; C: CREATE USER 'user2'@'localhost' IDENTIFIED TO '123'; D: CREATE USER user2@localhost IDENTIFIED TO '123';

    使用CREATE USER语句创建一个新用户,用户名为user2、密码为123 下面选项中,能实现上述功能的语句是 A: CREATE USER 'user2'@'localhost' IDENTIFIED BY '123'; B: CREATE USER user2@localhost IDENTIFIED BY 123; C: CREATE USER 'user2'@'localhost' IDENTIFIED TO '123'; D: CREATE USER user2@localhost IDENTIFIED TO '123';

  • 2022-05-29 问题

    登陆MySQL服务器,默认的用户名为 A: pwd B: user C: root D: localhost

    登陆MySQL服务器,默认的用户名为 A: pwd B: user C: root D: localhost

  • 2021-04-14 问题

    针对GET方式RESTful风格的请求http://localhost:8080/chapter14/user/1,后台方法接收参数的路径映射写法可行的是。

    针对GET方式RESTful风格的请求http://localhost:8080/chapter14/user/1,后台方法接收参数的路径映射写法可行的是。

  • 2022-06-07 问题

    MySQL的用户存放在哪个系统表中? A: root B: user C: sys D: localhost

    MySQL的用户存放在哪个系统表中? A: root B: user C: sys D: localhost

  • 2022-06-03 问题

    使用GRANT语句创建用户名为user1、密码为123,并授予该用户对chapter08.student表有查询权限。 下面选项中,能实现上述功能的语句是 A: GRANT SELECT ON chapter08.student FOR 'user1'@'localhost' IDENTIFIED BY '123'; B: GRANT USER SELECT ON chapter08.student TO 'user1'@'localhost' IDENTIFIED BY '123'; C: GRANT USER SELECT ON chapter08.student 'user1'@'localhost' IDENTIFIED BY '123'; D: GRANT SELECT ON chapter08.student TO 'user1'@'localhost' IDENTIFIED BY '123';

    使用GRANT语句创建用户名为user1、密码为123,并授予该用户对chapter08.student表有查询权限。 下面选项中,能实现上述功能的语句是 A: GRANT SELECT ON chapter08.student FOR 'user1'@'localhost' IDENTIFIED BY '123'; B: GRANT USER SELECT ON chapter08.student TO 'user1'@'localhost' IDENTIFIED BY '123'; C: GRANT USER SELECT ON chapter08.student 'user1'@'localhost' IDENTIFIED BY '123'; D: GRANT SELECT ON chapter08.student TO 'user1'@'localhost' IDENTIFIED BY '123';

  • 2022-06-19 问题

    用create user命令创建名为“u1”、主机名为localhost的数据库用户,密码为111。

    用create user命令创建名为“u1”、主机名为localhost的数据库用户,密码为111。

  • 1 2 3 4 5 6 7 8 9 10