> > >

MySQL MCQs

What is the correct syntax to create a new user in MySQL?

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

CREATE USER 'newuser'@'localhost' SET PASSWORD 'password';

CREATE USER 'newuser'@'localhost' PASSWORD ‘'password';

CREATE USER 'newuser'@'localhost' ASSOCIATED BY 'password';

Answer

Correct Answer: CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it