mysql commands

1. change root password for root@'%'

• login as root

        mysql -u root -p 

• query to check root record

        select user,host,password from mysql.user where user='root' and host='%'; 

• change the password of root@'%'

        update mysql.user SET Password=PASSWORD('complexpassword') where user='root' and host='%'; 

• query to check if changed

        select user,host,password from mysql.user where user='root' and host='%';