In a MySQL Server, as a DBA you are required grant all privileges as a global privilege to user Accountant. Which of the following SQL queries is to be executed to accomplish this task?

GRANT ALL on *.* TO Accountant@localhost;

GRANT * TO Accountant@localhost;

GRANT --ALL-PRIVILEGES on *.* TO Accountant@localhost;

GRANT ALL PRIVILEGES TO Accountant@localhost;

Verified Answer
Correct Option - a

To get all Infosys Certified MySQL Administrator Exam questions Join Telegram Group https://rebrand.ly/lex-group-70b557

Telegram

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in

Updated on Fri, 22 Aug 2025