setup mysql passwd and user

shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(‘new_password’)
-> WHERE user=’root’;
mysql> FLUSH PRIVILEGES;