'MySql MySql' wont let me in.

Okay, I'm logged in as an administrator and in the command prompt but it wont let me enter the 'MySql MySql' section anymore. Even when it did let me in it didn't let me change the root password. Any idea?

it's lower case. mysql.

Are you using the right syntax?

##: mysql -u username -p

enter password: password

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 781935 to server version: 4.0.4-beta

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

> use mysql;
Database changed

> update user set password=password("newpassword") where user='root';
Query OK, 2 rows effected (0.02 sec)

> flush privileges;
Query OK, 0 rows affected (0.02 sec)

> \q
Bye

##:

P.S. that was the syntax for a 3.23.x series MySQL. If you are using a 4 series the syntax will differ somewhat.

after the

update user set password=("****") where user='root';

setp I got this error:

ERROR 1146: Table 'mysql.user' doesn't exist