On 23 Mar, 10:00, drblitzkr...@gmail.com wrote:
> 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 | | |

how strange that `user` doen't appear as a column here???