use mysql;
set password=password('rootpassword');
update user set password=password('rootpassword') 
where user='root';
delete from user where password='';
grant all privileges on testdatabase.* to kiat 
identified by 'yourpassword';
flush privileges;