MySQL Bugs: #19576: GRANT ALL on stored procedures and view creation requires client reconnection

Bug #19576	GRANT ALL on stored procedures and view creation requires client reconnection
Submitted:	6 May 2006 6:23	Modified:	26 Jun 2006 12:44
Reporter:	cristian vanti	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1.9-beta	OS:	Linux (linux)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
I gave GRANT ALL PRIVILEGES ON * TO root@192.168.1.3 WITH GRANT OPTION; on local console of a linux machine;

I try to create a procedure or a view from a remote Windows machine but I always get 
"Access denied for user 'root'@'192.168.1.3' to database 'test'"
Table creation does work;
DROP PROCEDURE gives me "alter routine command denied to user 'root'@'192.168.1.3' for routine 'test.dummy'"

FLUSH PRIVILEGES has no effects.

Only after restarting client I was able to do all the work.
 

How to repeat:
create procedure dummy begin end; 
from a remote windows (only) mysql client

Thank you for the bug report. I was unable to repeat with the binary
release package and with the current source server.

miguel@hegel:~/mysql-5.1.9-beta-linux-i686> bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.1.9-beta

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.33' 
    -> IDENTIFIED BY 'miguel' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

c:\mysql\bin>mysql -uroot -hhegel -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.1.9-beta

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> USE test
Database changed
mysql> CREATE PROCEDURE dummy() BEGIN END;
Query OK, 0 rows affected (0.00 sec)

mysql> DROP PROCEDURE dummy;
Query OK, 0 rows affected (0.00 sec)

mysql>

Unlucky my test was with a fresh install of the mysql db grant tables,
it is possible for you to test with a fresh install and try to repeat?. If
you won't able to repeat then something in your current grant tables
provokes that behavior and we need to find what.

Thanks in advance.

At now I can't do a new installation. I will be able in few days.

Thank you for the feedback. Please reopen when you will have result
with the new server.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Hi Miguel,

I wanted to create a stored procedure using the query browser to connect to my database remotely and it keeps telling me that access is denied to user.

I tried granting myself all privileges and I got the same thing back. I'm using mysql 5.0.67-log on windows xp.

Cheers,

Alban