实现将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’;
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’;
A
举一反三
- 将root用户的密码设置为“123456”,下列语句正确的是( )。 A: MODIFY USER 'root'@'%' IDENTIFIED BY '123456' B: MODIFY USER 'root'@'%' PASSWORD '123456' C: ALTER USER 'root'@'%' IDENTIFIED BY '123456' D: ALTER USER 'root'@'%' PASSWORD '123456'
- 下面通过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: mysql_open("localhost","root","root"); B: mysql_connect("localhost","root","root"); C: connect_mysql("localhost","root","root"); D: dbopen("localhost","root","root");
- 实现将root用户的密码修改为1111的语句，正确的是（）
- 登陆MySQL服务器,默认的用户名为 A: pwd B: user C: root D: localhost
内容
- 0
MySQL的用户存放在哪个系统表中？ A: root B: user C: sys D: localhost
- 1
使用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';
- 2
中国大学MOOC: 实现将root用户的密码修改为1111的语句，正确的是（）
- 3
Linux系统命令提示符为[user1@localhost root]$，当然用户所在目录为（ ） A: user B: localhost C: root D: $
- 4
Linux系统命令提示符为[user1@localhost root]$，当然用户所在目录为（ ） A: user B: localhost C: root D: $