下列SQL语句中能查看MySQL数据库用户帐号的是()。 A: SELECT user FROM mysql.user; B: SELECT USER();c、SELECT * FROM user;D、SELECT user FROM mysql;

下面使用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';

哪个能实现删除用户的命令( )。 A: delete from MySQL.user B: delete user C: drop root D: truncate user

在mysql.user表中（）和（ ）用于区分MYSQL中的用户。

MySQL服务器中的用户信息存储在mysql.user表中。（ ）

mysql.user表中【 】和【 】字段组成复合主键用于分区MySQL中的账户

在 MySQL 中,删除用户的命令是( ) A: DROP USER B: REVOKE USER C: DELETE USER D: REMOVE USER

补全以下代码： DriverManager.getConnection(url,user,password); url="jdbc:mysql://():()/nkzy"; user="()"; passsword="()";

下面通过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';

MYSQL中，可以使用_________语句来为指定数据库添加用户 A: set user B: create user C: update user D: drop user