% mysql -u root users
mysql> UPDATE users SET password = 
mysql> password('secretpassword') WHERE User = "root";
mysql> GRANT ALL PRIVILEGES ON yourdatabase.*
mysql> TO 'underpriviledgeduser'@'hostname';
mysql> UPDATE users SET password = 
mysql> password('anothersecretpassword') WHERE
mysql> User = "underpriviledgeduser";
mysql> FLUSH PRIVILEGES;