Hi, I'm trying to perform the simple task of creating a user and
granting him all privileges. The password of the user I created
remains blank. As root, and have tried:

update user set password=password('mypass') where user='myuser';
grant all privileges on *.* to 'cms'@'%' identified by 'mypass' with
grant option;

both of these return the following:
Query OK, 0 rows affected (0.01 sec)
Rows matched: 1 Changed: 0 Warnings: 0

The password remains blank. So if it's matching a row, why isn't it
changing it?


The following is returned from "select * from user where
user='myuser'":

tdown_priv | Process_priv | File_priv | Grant_priv | References_priv |
Index_priv | Alter_priv | Show_db_priv | Super_priv |
Create_tmp_table_priv | Lock_tables_priv | Execute_priv |
Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv
| Create_routine_priv | Alter_routine_priv | Create_user_priv |
ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions |
max_updates | max_connections | max_user_connections |
+------+------+-------------------------------------------
+-------------+-------------+-------------+-------------+-------------
+-----------+-------------+---------------+--------------+-----------
+------------+-----------------+------------+------------
+--------------+------------+-----------------------+------------------
+--------------+-----------------+------------------+------------------
+----------------+---------------------+--------------------
+------------------+----------+------------+-------------
+--------------+---------------+-------------+-----------------
+----------------------+
| % | cms | *E8AFA04A0A8FAC8CC12C5FCA645514E7DF01F0D6 |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y | Y | Y
| Y | Y | Y |
Y | Y | Y |
Y | | |