On Mar 23, 7:07 pm, "Captain Paralytic" <paul_laut...@yahoo.com>
wrote:
> 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???


Sorry, looks like this part got cut off when I pasted:
| Host | User | Password | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv

The important columns from the "user" table of the "mysql" database
are "host", "user" and "password". When trying to change any of
these, it doesn't seem to allow it.