使用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’;
喵查答案：CREATE USER ‘user2’@’localhost’ IDENTIFIED BY ‘123’;