智慧职教: 更改用户user1的密码为111111
举一反三
- 新建用户user1，给用户user1设置密码为password
- 下面使用DROP USER语句删除用户user1的语句中,正确的是 A: DROP USER user1@localhost; B: DROP USER 'user1'.’ocalhost'; C: DROP USER user1.localhost; D: DROP USER 'user1'@'localhost';
- 更改用户user1为User1的命令是()。 A: usermod –name User1 user1 B: usermod –c User1 user1 C: usermod –u User1 user1 D: usermod –l User1 user1
- 更改用户user1为User1的命令是()。 A: usermod –name User1 user1 B: usermod –c User1 user1 C: usermod –u User1 user1 D: usermod –l User1 user1
- 使用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';