How can I revoke all privileges from the 'root' user on 'localhost'?

Question

Grade: Education Subject: Support
How can I revoke all privileges from the 'root' user on 'localhost'?
Asked by:
68 Viewed 68 Answers

Answer (68)

Best Answer
(157)
Connect to MySQL as a user with administrative privileges. Then, execute the following SQL statement: `REVOKE ALL PRIVILEGES ON *.* FROM 'root'@'localhost';`