How To Set Mysql Database User Password Root Reset Forgot Get Retrieve

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:

Remember, XXXXXXX is whatever password you want to set.