tags 392781 + unreproducible
stop
Hello Björn
On 2006-10-13 Björn Wiberg wrote:
> How to repeat (as "root" user in mysql):
>
> create database useraccdb;
> insert into user (host, user, password) values ('localhost', 'useracc',
> password('SECRET')); grant all on useraccdb.* to useracc;
> select * from db;
>
> This will show something like:
>
> /../
> | % | useraccdb | userac | Y | Y | Y
> /../
>
> ...which is incorrect, it should show "useracc", not "userac".
>
> Curious as to whether you get the same results.
No, here it seems fine:
(sarge)[EMAIL PROTECTED]:~$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.1.11-Debian_4sarge7-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> create database useraccdb;
Query OK, 1 row affected (0.00 sec)
mysql> insert into user (host, user, password) values ('localhost',
mysql> 'useracc', p
assword('SECRET'));
Query OK, 1 row affected (0.00 sec)
mysql> grant all on useraccdb.* to useracc;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from db;
+------+-----------+---------+-------------+-------------+-------------+--------
-----+-------------+-----------+------------+-----------------+------------+----
--------+-----------------------+------------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv |
Delete_ priv | Create_priv | Drop_priv | Grant_priv | References_priv |
Index_priv | Alt er_priv | Create_tmp_table_priv | Lock_tables_priv |
+------+-----------+---------+-------------+-------------+-------------+--------
-----+-------------+-----------+------------+-----------------+------------+----
--------+-----------------------+------------------+
| % | useraccdb | useracc | Y | Y | Y |
Y | Y | Y | N | Y | Y | Y
| Y | Y |
+------+-----------+---------+-------------+-------------+-------------+--------
-----+-------------+-----------+------------+-----------------+------------+----
--------+-----------------------+------------------+
1 row in set (0.00 sec)
mysql>
bye,
-christian-
