SEO

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 | | |

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???

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.