在MySQL中创建一个新用户,用户名为cvc1,密码为123,仅允许该用户从本地客户端登录,下列语句正确的是( )。
A. CREATE USER 'cvc1'@'localhost' IDENTIFIED BY '123'
B. CREATE USER 'cvc1'@'localhost' PASSWORD '123'
CREATE USER 'cvc1'@'%' IDENTIFIED BY '123'
D. CREATE USER 'cvc1' @'%' PASSWORD '123'
将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'