下列语句中创建新用户的语句为( )
A. insert into mysql.user(Host,User,Password) VALUES(.host_name., .user_name.,PASSWORD(.password.)
B. create user username@localhost identified by ‘123456’
C. insert into mysql.user(Host,User,Password) VALUES(host_name, user_name,PASSWORD(password)
D. create user username@localhost identified by 123456