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

2022-06-03

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

答案：

B

0
下面使用DROP USER语句删除用户user1的语句中,正确的是 A: DROP USER user1@localhost; B: DROP USER 'user1'.’ocalhost'; C: DROP USER user1.localhost; D: DROP USER 'user1'@'localhost';
1
添加用户CREAT USER的一般格式为（？） A: Create [@主机名] [Identified By ]…[, …] B: Create User Identified By 用户名 C: Create User 密码用户名 D: Create user [@主机名][identified by ]……[,……]
2
下面选项中，用于将表user中字段age值更新为55的SQL语句是 A: ALTER TABLE user set age=55; B: UPDATE user set age=55 where age=55; C: UPDATE user set age=55; D: UPDATE user set age=55 where age<=55;
3
删除用户账户命令是( ) A: DROP USER B: DROP TABLE USER C: DELETE USER D: DELETE FROM USER
4
使用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';