After installing MySQL service, administrator should set a reasonably strong password using mysqladmin utility. In MySQL, user name of administrator is “root”. To change/set/reset password, you need to run two commands. The following shows the syntax of the commands.

[root@techpulp ~]# mysqladmin -u root password NEWPASSWORD
[root@techpulp ~]# mysqladmin -u root -h HOSTNAME password NEWPASSWORD

The following commands show example usage.

[root@techpulp ~]# mysqladmin -u root password y5FxEtrh
[root@techpulp ~]# mysqladmin -u root -h localhost password y5FxEtrh

As the commands you executed are stored in history file (~/.bash_history), you can avoid it by running following command before running mysqladmin utility.

[neo@techpulp ~]# echo $HISTFILE
/home/neo/.bash_history More >