Forgot mysql ROOT password

[Wanch]

It isn't on a machine that clients use but on a local machine I have for messing around with. The problem is I can't remember what the root user password is for MySQL.

# mysql -u root -p

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Anyone know how to reset this password?

[Jordan]

Ah, I've been there before. MySQL Manual has a great reference on how to do it for both Linux and Windows:

MySQL :: MySQL 5.0 Reference Manual :: B.1.4.1 How to Reset the Root Password

Let me know if you need any help.

[TotalPenguin]

That's bad mate. Did you solve it?

[SexYLinuX]

Don't you think that having the functionality of resetting the password can compromise security?

[Tor]

I think it can but if someone can gain root access to your system your security is already gone anyway.

[TotalPenguin]

True. Because that means that they already hacked you...

[SexYLinuX]

Hmm.. no I mean if the hack the database server, can't they hack the root account and gain root access on the database?

[TotalPenguin]

I've got no idea if that is possible.

[HappyUser]

Unless you hack the root user I don't think you will be able to hack his databases....right?

[Jordan]

In MySQL you set where people are allowed from. Most users are set to only access MySQL via localhost. Unless you have setup bad security permissions and have allowed users to access MySQL from any IP then you could risk being hacked.