GRANT ALL PRIVILEGES ON TESTPILOT.* TO testpilot@localhost IDENTIFIED BY 'password';


UPDATE mysql.user SET Password = OLD_PASSWORD('bungump') WHERE Host = 'localhost' AND User = 'bungump';
FLUSH PRIVILEGES;





SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');



GRANT ALL PRIVILEGES ON moodle_summer06.* TO moodleuser_summer06@localhost IDENTIFIED BY 'moodleuserpassword_summer06';

SET PASSWORD FOR 'mdl_summer06'@ 'localhost' = OLD_PASSWORD( 'mdl_summer06_password' ) ;