Change MYSQL root Password

Is very easy to change root password on Linux / BSD / Unix systems on propmpt line (shell) using a few commands.

Log in to your server as root

If you are setting mysql root password first time you can use:

Usign mysqladmin
1st way:
# mysqladmin password “password_you_want“

2nd way:
# mysqladmin -u root password “Npassword_you_want“

3rd way:
# mysqladmin -u root -h localhost password “password_you_want“

Use the same way if you want to change the current password:
# mysqladmin -u root password "password_you_want"

0 Comments: