mysql root password forgot

Posted on 2009-04-15
Medium Priority
Last Modified: 2012-05-06
Hi all,
            My os is RHEL5.
I am using mysql for database.
when i did
#mysql -u root -p
it asks for password
i forgot my password. when i put anything else it gives the message

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
can any body help me
any help will be appreciable
Question by:JATENDER1979
1 Comment
LVL 26

Accepted Solution

Tomas Helgi Johannsson earned 1500 total points
ID: 24146380

Follow this in the manual to reset the root password

   Tomas Helgi

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question