MySQL Bugs: #60683: MySQL not starting.

Bug #60683	MySQL not starting.
Submitted:	29 Mar 2011 8:04	Modified:	1 Apr 2011 11:39
Reporter:	Vivek V	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Charsets	Severity:	S1 (Critical)
Version:	5.0.89	OS:	Other (Ubuntu 6.06)
Assigned to:		CPU Architecture:	Any
Tags:	mysqld: ignoring option '--character-set-client-handshake' due to invalid value

Description:
On trying to restart a database after changing buffer setting for MyISAM and InnoDB, I get the following error in the error log:

110329  9:00:12 [Warning] /usr/local/mysql/bin/mysqld: ignoring option '--character-set-client-handshake' due to invalid value 'utf8'
110329  9:00:12 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'character_set_connection=utf8'
110329 09:00:12  mysqld ended

How to repeat:
I have changed the data buffer values for MyISAM and InnoDB and restarted.

I have tried reverting the changes back in my.cnf, but still get the same error.

I had not installed this instance and am re-starting the server for the first time.

Could you please try latest released version and comment the result here. Thanks in advance.

Hello Miguel,
   When I requested the Server admin team to start the instance using the root login, it worked!
I presume this is something to do with the MySQL file permissions, as I see that apart from the data directory all the other MySQL directories including the bin folder is owned by the root with only read and execute permissions to group and others.
Am I right in saying that changing the permission of this directories to the DBA login to help DBA's restart the MySQL instance?

Thanks and Kind Regards,
Vivek.

Thank you for the feedback.

This is not a bug, but permission issue in your environment.

Many Thanks for the update Sveta!

Kindly requesting to know which files should be owned by my login for me to start the MySQL instance.

Thanks and Kind Regards,
Vivek.