How do I reset my MySQL database root password?

Solution Verified - Updated -

Issue

I forgot the MySQL root password. How do I reset it?

# mysql -u root'
Access denied for user 'root'@'localhost' (using password: NO)'

Environment

  • Red Hat Enterprise Linux including:

    • Red Hat Enterprise Linux 3
    • Red Hat Enterprise Linux 4
    • Red Hat Enterprise Linux 5
    • Red Hat Enterprise Linux 6
  • mysql-server

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In