MYSQL set root password

if you want to change the password for mysql you can run this command to set a new one, you can run this in phpMyAdmin too:

SET PASSWORD FOR root@localhost = PASSWORD('NewPassword');