I just finished installed linux on a new server, i remember i installed mysql server, but don't remember what password i set to it. I tried to figure out what the password was. I worried because i ddin't want to re-image the server again. After researching, i came across an article on a book that show you how to set the root password. Luckely, i never se the root password, which is bad because you should always set the password, once you have the root password, you can do many things like reset, change, edit your password, otherwise, forget it, you won't be able to get it back. so to set your password, login to your linux shell prompt, and send this command:

CODE:
mysqladmin -u root password XXXXXXX


Remember, XXXXXXX is whatever password you want to set.