Apart of the MySQL command line interface a a system administrator is able to change MySQL user’s password using mysqladmin
command directly from a shell command line. The following linux command will change/update a current MySQL root password given that current password is blank:
# mysqladmin -u root password 'newpass'
The above command will change MySQL root’s password to newpass
. To change MySQL root’s password to abc123
where that current password is set to newpass
we need to use -p
option which allows us to supply the mysqladmin
command with a current user password. For example:
# mysqladmin -u root -pnewpass password 'abc123'
Test the new password:
# mysqladmin -u root -pabc123 ping mysqld is alive
Please note the deliberate lack of space between -p
option and current user password. The above method can be used to change password for any other user.