MySQL user password and privilege setup

Default user name and password for MySQL: root, mysql
Methods to add or change user's password
1. phpMyAdmin: The php frontend. Use SQL to update the user database directly. Don't forget to use the function password(strPassword) to encrypt the password.
2. On the console:
>mysqladmin -u root -pold password newpasswd
3. mysql> INSERT INTO mysql.user (Host,User,Password) VALUES ('%','system', PASSWORD('newpasswd'));
　mysql> FLUSH PRIVILEGES
4. mysql> REPLACE INTO mysql.user (Host,User,Password) VALUES('%','system',PASSWORD('newpasswd'));
　mysql> FLUSH PRIVILEGES
5. mysql> SET PASSWORD FOR system@"%" = PASSWORD('newpasswd');
6. mysql> GRANT USAGE ON *.* TO system@"%" IDENTIFIED BY 'newpasswd';

The method to setup the privilege in MySQL
mysql>GRANT ALL PRIVILEGES ON *.* TO system@localhost IDENTIFIED BY 'newpasswd' WITH GRANT OPTION;