Sometime we don’t have any idea about the old MySQL root password,but we have to use root password to manage our application so automatically you are going to behind the topic how to change MySQL root password without knowing the old password,here am using Linux os and we have Linux root ssh login details.So lets find out the steps to change root password
1) Stop the server
#service httpd stop
2) open MySQL section
#mysql
3) Select Mysql Database
> use mysql
4) Update root Password Section
>update user SET password=password(“hello@123”) where user=’root’;
if you are getting error for changing MySQL root password follow steps 5
5) show tables
> show tables user table exits
6) Find user table fields
> describe user No password field instead of password we have authentication_string fields
7) Finally update new password
update user SET authentication_string=password("hello@123") where user='root'