MySQL Creating account and changing password

Enter password: ****

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4

Server version: 5.0.86-community-nt MySQL Community Edition (GPL)



Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.



mysql> use mysql;

Database changed

mysql> insert into user (host,username,password) values ("%",username("ROOT"),password("root"));