实现将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’;
举一反三
- 将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