Hi,
finally I solved the problem by myself, yippiee :-)
During the upgrade from 3.x to 4.x I didn't create the indizes for the
user, host und db-tables (I didn't use the mysql-fix-privilege-tables
skript cause I did not whether there was one at all). The missing
indizes caused MySQL to create a new user every time I granted rights
to an user, whether it was existing or not.
Greetings
Lutz
----- Original Message -----
From: "Lutz Maibach" <[EMAIL PROTECTED]>
To: "mysql Liste" <[EMAIL PROTECTED]>
Sent: Monday, January 26, 2004 3:01 PM
Subject: Inserting One new User = 2 entries in mysql.user when using
MySQL 4.0.17?!
> Hello,
>
> I'm using the same sqls to append a new user to the MySQL-DB since 2
> years.After upgrading from 3.23.57 to 4.0.17 I added a
replication-user
> with the same script that always worked right. When controlling the
new
> entry I was really surprised that I found two entries for the new user
> instead of one.
>
> To get rid of this "uninvited guest" I studied the manual again and
> found out that in MySQL 4.0.x a replication user now longer got the
> file_priv but the replication_slave_priv instead. So I deleted the two
> user-entries, changed the script to the one shown below
and.........got
> again 2 entries for the new user which are different in the privileges
> they own.
>
> Here are the SQL-Statements I used:
> insert into user (host,user,password) values
> ('%','repltest2',password('test1234'));
> flush privileges;
> grant super, reload, replication slave on *.* to repltest2@'%'
> identified by 'test1234';
> flush privileges;
>
> ...and here is what I see in the mysql.user-table:
>
+------+---------+------------------+-------------+-------------+-------
> ------+-------------+-------------+-----------+-------------+---------
--
> ----+--------------+-----------+------------+-----------------+-------
--
> ---+------------+--------------+------------+-----------------------+-
--
> ---------------+--------------+-----------------+------------------+--
--
> ------+------------+-------------+--------------+---------------+-----
--
> ------+-----------------+
> | Host | User | Password | Select_priv | Insert_priv |
> Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
> Shutdown_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 | ssl_type | ssl_cipher |
x509_issuer
> | x509_subject | max_questions | max_updates | max_connections |
>
+------+---------+------------------+-------------+-------------+-------
> ------+-------------+-------------+-----------+-------------+---------
--
> ----+--------------+-----------+------------+-----------------+-------
--
> ---+------------+--------------+------------+-----------------------+-
--
> ---------------+--------------+-----------------+------------------+--
--
> ------+------------+-------------+--------------+---------------+-----
--
> ------+-----------------+
> | % | repltest2 | 38fb843c55682a6f | N | N | N
> | N | N | N | Y | N
|
> N | N | N | N | N |
N
> | N | Y | N | N
|
> N | Y | N | |
> | | | 0 | 0 |
> 0 |
> | % | repltest2 | 38fb843c55682a6f | N | N | N
> | N | N | N | N | N
|
> N | N | N | N | N |
N
> | N | N | N | N
|
> N | N | N | |
> | | | 0 | 0 |
> 0 |
>
+------+---------+------------------+-------------+-------------+-------
> ------+-------------+-------------+-----------+-------------+---------
--
> ----+--------------+-----------+------------+-----------------+-------
--
> ---+------------+--------------+------------+-----------------------+-
--
> ---------------+--------------+-----------------+------------------+--
--
> ------+------------+-------------+--------------+---------------+-----
--
> ------+-----------------+
>
> "User 1" got the right privileges while "User 2" haven't got a single
> privilege.
>
> Anyone knows what's going wrong?
>
> Greetings from Germany
>
> Lutz Maibach
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
