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]
