Bug #35162 --skip-grant-tables should probably block ROUTINEs from being created

• Submitted: 8 Mar 2008 13:51
• Modified: 8 Mar 2008 18:27
• Reporter: Tobias Asplund
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.1.23
• OS: Any
• CPU Architecture: Any

[8 Mar 2008 13:51] Tobias Asplund

Description:
You can create a procedure that can not be executed if you run with --skip-grant-tables

How to repeat:
mysql> -- The server has been started with --skip-grant-tables
mysql> use test
Database changed
mysql> CREATE PROCEDURE p1 () SELECT 10;
Query OK, 0 rows affected (0.03 sec)

mysql> CALL p1;
+----+
| 10 |
+----+
| 10 | 
+----+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

# Restarting the server here without --skip-grant-tables

mysql> CALL p1;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: test

ERROR 1449 (HY000): There is no ''@'' registered
mysql>

[8 Mar 2008 18:27] Valeriy Kravchuk

Thank you for a bug report. It is indeed a duplicate of bug #21854.