注意:此页面搜索的是所有试题
题目内容
(国家开放大学数据库运维)
MySQL修改root用户密码的语法为( ACD )
A. mysqladmin –u user_name –h host_name –ppassword “new_password”;
B. INSERT INTO mysql.user (password,root,hostname) VALUES (PASSWORD(‘rootpassword’),”root”,”hostname”);
C. SET PASSWORD=PASSWORD(.rootpassword.);
D. UPDATE mysql.user SET password=PASSWORD(.rootpassword.) WHERE user=”root” and host=”host_name”;
A. mysqladmin –u user_name –h host_name –ppassword “new_password”;
B. INSERT INTO mysql.user (password,root,hostname) VALUES (PASSWORD(‘rootpassword’),”root”,”hostname”);
C. SET PASSWORD=PASSWORD(.rootpassword.);
D. UPDATE mysql.user SET password=PASSWORD(.rootpassword.) WHERE user=”root” and host=”host_name”;
参考答案

