MySQL Bugs: #20580: multiple init-connect options not handled gracefully

Bug #20580	multiple init-connect options not handled gracefully
Submitted:	20 Jun 2006 16:36	Modified:	28 Nov 2008 22:02
Reporter:	Matthew Lord	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Options	Severity:	S3 (Non-critical)
Version:	5.0.23	OS:	Linux (linux (x86), solaris 9,10 (sparc)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
If you have more than one init-connect option specified (2 or more lines) then users without the SUPER privilege cannot connect or run commands.

How to repeat:
./bin/mysqld_safe with --init-connect="set @@autocommit=0" --init-connect="set names utf8" &

mysql -u '' 

show databases;

Suggested fix:
We should either produce an error at mysqld startup time or simply let the last instance override the previous values.

cannot repeat on 5.0.66-debug